Log In
Register
Home
New Member
February 17, 2022
Offline
I would like to use PQ to split a column of names obtained from a csv file (over which I have no control) which contains inconsistent data.
I have tried transposing and filling up and down, but cannot get a clean result. Ideally I would end up with 3 columns:
Honorific, First name, Surname
Mr Alan van de Velde
Mr Bob Vandevelde
Mrs Christine Vande Velde
David van de Velde
Ms Ellen Vanden velde
Fran Van de Vel De
Thank you
See Answer
Moderators
January 31, 2022
Offline
That will be a challenge. You could start with listing out all possible honorifics. Then you can at least identify the rows that have one and extract them. Then, will some people have double first names separated by a space?
If not, the attached file could help you on your way.
New Member
February 17, 2022
Offline
Thank you very much Riny
Separating out the honorifics will definitely help.
As to first names, you are also correct - we have Annabelle, Anna Belle and Anna-Belle as examples.
So using your examples using custom columns for the surnames, I will try to sort these out in the same way.
Many thanks for your time.
Answers Post
1 Guest(s)
