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

 

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.

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