3 Replies Latest reply: May 15, 2014 10:01 AM by Dr. Siewert RSS

    First Name with Init - Need to split

      Have a first name field which includes the initial (if present) Example:  FirstName=Harald G.

       

      I need to extract the first name into a unique field, and extract the Middle initial to its own field as well.

       

      Problem I'm having is when there is no Middle initial, thus no '.'.  Also, I have the occassional name like E. Thomas Lastname.  That one really makes it crazy.  I have Monarch 9

       

      Dr. Siewert