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.