TIBCO Spotfire

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

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