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
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
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.