AnsweredAssumed Answered

Remove an apostrophe in a name

Question asked by wcallman on Sep 29, 2018
Latest reply on Oct 7, 2018 by keywords

I am using the following formula to format a user id number:

Left ( Master::A1_Name_LastName; 3 )  &  Left (Master::A1_NameFirstName ; 2 )  & 

Right ( "00" & Month ( Master::A1_BirthDate ) ; 2 ) & Right ( "00" & Day ( Master::A1_BirthDate ) ; 2 )

 

The formula works great, (thanks for your help earlier today on leading zeros.

 

Now a new bug has popped up.

 

Last name: Crazy

First name: G'oing

 

so the result is CraG' and it needs to be CraGo

I would like to add a statement to the above statement if possible, however

I can create a new data field for first name to store the cleaned name.

 

Have a great weekend everyone and thanks.

Outcomes