Experian Data Quality Community
-
Make your own reusable RIGHT function to return a number of characters from the end of a text string
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…
-
Extracting titles and honorifics from names (advanced)
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…
-
Extract Title from Names
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…
