Page 1 of 1

Remove specific character (First name) in name field

PostPosted: Thu Aug 16, 2018 5:41 pm
by Aech
Hi,

I have a set of names with the format Title, First name and Last name like below

Mr FAAA LBBBB
Ms FCCC LDDDD
Mrs FEEE LGGGG
Miss FOOO LPPPP
Prof FSSS LHHHH


I want to remove the First name from these records and display only Title and Last name as below

Mr LBBBB
Ms LDDDD
Mrs LGGGG
Miss LPPPP
Prof LHHHH


I read SQZ parameter can be used to left/right squeeze the spaces but not sure if that is appropriate in my scenario.
Could you please let me know what other options I have to achieve this.

Re: Remove specific character (First name) in name field

PostPosted: Thu Aug 16, 2018 10:58 pm
by Akatsukami
How are you planning to remove the first names?

Re: Remove specific character (First name) in name field

PostPosted: Fri Aug 17, 2018 1:27 pm
by NicC
Use PARSE to split the fields into 3 variables (%00, %01, %02) then BUILD using only the first and third variables (%00, %02).