Learn, collaborate and solve problems with like-minded data quality enthusiasts.
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
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…
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…
