Experian Data Quality Community
-
Is there a Zip code validation Regex code library?
Hi All, We need to check and validate the Postal codes in our database for all the countries and I see that we have these built-in format validations for these countries: Do you know if there is a library in Aperture for regex codes to check the Postal code format for all the countries? Many thanks! Kind regards, Vera
-
How to check if an input value contains numbers
In Aperture Data Studio, in order to check if an input value contains numbers, you can use the Matches Expression function. The Matches Expression function uses a regular expression to specify a pattern to be matched against. If you are not familiar with a regular expression, it may take some exploration to get to the…
-
Fuzzy Match with Regular Expressions
Imagine you have an address field containing variation of city names, for example: You need to determine the country based on the city name. You have an official list of countries and their cities like this: With any exact match techniques, some of the values will not be matched since they do not appear in the official…
