Learn, collaborate and solve problems with like-minded data quality enthusiasts.
A customer was asking if there is a way to achieve something similar to the RIGHT() function within Aperture Data Studio. We do have a flexible Substring function that you can use. Use -1 to indicate that the End position should be the last character of the Input value. Specify any negative number to return a number of…
In this earlier post I described how you might want to extract titles or honorifics from a name string, this might be important for a marketing campaign where to you wish to personalize your communication by saying dear sir or madam. Unfortunately the data isn't always as we want it and sometimes we land up with names of…
During the course of the data preparation that you might be doing on names, you might have occasion to pull out the Title or honorific associated with the name. In this example we assume all names have an honorific, if some don't you need to use conditional logic which i will cover separately. You have at least two…
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…
