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 approaches that you can use here

The first uses the Delimited Substring function - this view is from the QUICK FUNCTION builder


The second uses the substring function and works out the position of the delimiter - this view is from the CUSTOM FUNCTION builder

Neither choice is technically more expensive than the other in terms of time it takes for the application to perfom the task.

Both the Substring and the Delimited Substring function are available both the QUICK and CUSTOM function builder screens

Sign In or Register to comment.