Best of Support

Rearrange text values

Issue

Assuming that I have a field that is formatted as "John F. & Terry L." how do I separate out the first and last names into separate fields?

Solution

Let's assume: 

%[ContactFirstName = "John F. & Terry L."] 

 

%[ClientName = Element(1, ContactFirstName, "&")]

%[ClientName = Rtrim(ClientName)]

%[ClientFirstName = Element(1, ClientName, " ")]

%[ClientMiddleName = Element(2, ClientName, " ")]

 

%[SpouseName = Element(2, ContactFirstName, "&")]

%[SpouseName = Ltrim(SpouseName)]

%[SpouseFirstName = Element(1, SpouseName, " ")]

%[SpouseMiddleName = Element(2, SpouseName, " ")]

 

Result: 

Client Name    

%[ClientName]

Client First Name   

%[ClientFirstName]

Client Middle Name 

%[ClientMiddleName]

 

 

Spouse Name 

%[SpouseName]

Spouse First Name  

%[SpouseFirstName]

Spouse Middle Name 

%[SpouseMiddleName]

 

Dan Todes