3 Replies Latest reply on Jun 24, 2011 5:39 AM by Mitch

    Extracting an Initial from a First Name Field

    Mitch

      Title

      Extracting an Initial from a First Name Field

      Post

      Hi,

      Is there a way to extract and initial out of a First_ Name Field with the full name entered.?  Example;  

      First_Name=John

      Initial_Field=J

       

      Better still, extract the first name initial from the First_Name Field and combine it with a middle name Initial from the Middle_Name Field along with appropriate full stops....  Example:

      First_Name=John

      Middle_Name= William

      Initial_Field=J. M.

      Thanks in advance.

      Mitch