AnsweredAssumed Answered

Parsing Data

Question asked by LenLevin on Nov 11, 2015
Latest reply on Nov 11, 2015 by LenLevin

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.