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…
Join us in London on Thursday, 10th July, for an exclusive in-person Data Governance Masterclass featuring Nicola Askham – The Data Governance Coach. This event is designed for data leaders like you who are looking to enhance their governance strategies, gain insights from industry experts, and connect with peers through…
