Data_SystemAnal
5 years agoQrew Cadet
Extract Initials
Hello everyone,
I have this formula (Rich Text field )
var text FirstName = If([PreferredFirstName]="", [FirstName], [PreferredFirstName]);
var text MiddleName = If([PreferredMiddleName]="", [MiddleName], [PreferredMiddleName]);
var text LastName = If([PreferredLastName]="", [LastName],[PreferredLastName]);
$LastName&", "&$FirstName&" "&$MiddleName
OUTPUT: "Ponce Edson I"
HOWEVER, I AM LOOKING TO USED THE SAME FORMULA IF IS POSSIBLE THAT THE OUTPUT WILL BE ONLY INITIAL
OUTPUT WILL BE: "PEI"
------------------------------
Edson
------------------------------
I have this formula (Rich Text field )
var text FirstName = If([PreferredFirstName]="", [FirstName], [PreferredFirstName]);
var text MiddleName = If([PreferredMiddleName]="", [MiddleName], [PreferredMiddleName]);
var text LastName = If([PreferredLastName]="", [LastName],[PreferredLastName]);
$LastName&", "&$FirstName&" "&$MiddleName
OUTPUT: "Ponce Edson I"
HOWEVER, I AM LOOKING TO USED THE SAME FORMULA IF IS POSSIBLE THAT THE OUTPUT WILL BE ONLY INITIAL
OUTPUT WILL BE: "PEI"
------------------------------
Edson
------------------------------