Parsing Names

[wally buch]

I have a calculation to find a middle name that does not return any text. The calculation is for parsing the middle name in a string that may contain a title, such as Mr, Dr, etc is:

 

 

 

Case(IsEmpty(Title) = 1 and MiddleWords(FullName; 2; 1) - NameLast; MiddleWords(FullName; 2; 1); 

IsEmpty(Title) = 0 and MiddleWords(FullName; 3; 1) - NameLast; MiddleWords(FullName; 3; 1); "")

 

This is accepted as valid but returns only a blank. Any help would be appreciated

 

[Lee Smith]

As you can see, each piece of information should have had its own field.

 

If you were to do a search for parsing names, you would find numerous discussion on this need. See if this gets you started.

[Lee Smith]

Are you still using v9 client? if you have upgraded to Advance, there is a Custom Function that can help too here fnNameParser