Parsing a name with a middle inital

[Gary1478]

Does anyone have a quick script or calculation for parsing a full name? (some with a middle initial an some without) The calculation would parse a name in a field called full name and put the first name in the first name field, middle initial (if there is one) in the middle initial field and he last name in the last name field.

Thanks.

Gary

[efen]

There have been several posts in the past about this, for example

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

http://fmforums.com/forum/showtopic.php?tid/193274/post/281326/hl/parse++name/fromsearch/1/

http://fmforums.com/forum/showtopic.php?tid/192122/post/276055/hl/parse++name/fromsearch/1/

Search the forum with parsing + name