Extracting Names from single field

[jpotter]

I'm trying to extract DOE, JOHN B & JANE C/ DOE JOHN B JANE C into these fields.

First Name: JOHN B

Last Name: DOE

Spouse Name: JANE C

I have tried many different calculations, and I'm only successful with the last name and the spouse name (first word and last word) I don't seem to be able to make the First Name (middle words) to work.

Any suggestions?

[efen]

See

http://fmforums.com/forum/showtopic.php?tid/214996/post/357337/hl/parse++name/fromsearch/1/#357337