Re: Extracting names from a text column

Christof — Sun, 03 Jun 2012 22:15:01 GMT

You should work with the spaces to cut the string into pieces.

Find(" ",[NameCol]) gives you the first space in the text.

Work work with expressions like :

mid([NameCol],find(" ",[NameCol],99)+1) to cut off everything before the first Space.

You can handle multiple exeptions by usin the "case when" statement.

I order to separate the name string at the seconf uppercase letter in the string you should be able to use a Regular Expression.

If you struggle, let me know and we can try to fix it here in the forum.

Chirstof

Extracting names from a text column

kdawg — Thu, 24 May 2012 13:42:59 GMT

I am working with a dataset that has a text column that should appear as below:

*X Smith,John, 123456, 11-DEC-10.

Unfortunately it sometimes is formatted incorrectly and appears like this:

*X SmithJohn 123456 11-DEC-10

In either case, I need to extract the full name, John Smith, from the data.

When the data is correctly formatted, it is no problem. But I haven't found a solution for the second case. Any suggestions?

thanks,

Kevin