Extract First Name, Middle Initial and Last name from Full Name
I am trying to deal with the fact that many times my company leases lists from third parties in which the first name, middle initial, and last name are contained in one field. I have tried to set up calcuation fields to split out first name, middle initial and last name, but I am not a practiced writer of calculations and have only been able to produce the most simple way of extracting the first name and last name. I have been unable to extract the middle initial. This is a more complicated task because a middle initial may or may not be included in the full name. Also, the calucations that I have employed for first name and last name do not take into account titles or suffixes.
Any help would be appreciated.
Here is the calucation I employed to extract the first name:
LeftWords ( Full Name ;1)
Here is the calucation that I employed to extract the last name:
RightWords ( Full Name ; 1 )