Scripting to find middle name

[Arkansas]

I need help with scripting to find the middle initial or name when full name might be John Smith, John A. Smith, or John Allen Smith.

I can't seem to get the Middle Name field to be empty in the first instance.

[comment]

See if any of these helps:

http://fmforums.com/forum/showtopic.php?tid/110627

http://fmforums.com/forum/showtopic.php?tid/169812

http://fmforums.com/forum/showtopic.php?tid/172155