AnsweredAssumed Answered

Extracting an Initial from a First Name Field

Question asked by Mitch on Jun 7, 2011
Latest reply on Jun 24, 2011 by 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

Outcomes