I am a FMP neofite.
I am trying to separate the data in a field into three separate fields. The data is First Name, Last Name, Middle Initial and Date of Birth in the format LN,[space] FN[space]MI[space]9/10/1968. I want to delete the 'comma' as part of the separation.
I have the data field and the three separate fields. Is there a way to separate the data into three individual fields in one calculation. I only need to do it one time
I googled this and found some help about parsing. Have not had much help in making this work.
Any help would be treating appreciated.