I have the following strings in a large dataset.
I am looking for strings with this pattern:
1. SURNAME, Given Name
2. MADEUPSURNAME, Dagivenn Ame
3. MOREEXAMPLE, Hope Ithelps
I've tried; ^(\d+)\. ([A-Za-z]+), ([A-Za-z]+)$ but it only returns 1 out of many... not sure what I'm missing here.
Thanks!
-Cal
Solved! Go to Solution.
does this help
Hi @Raj
Thanks! But the numbers 1. 2. 3. are part of the string.
Your formula works if the numbers are not included. Could you have a look and revise please?
^(\d+).([A-Za-z\s'-]+), ([A-Za-z\s'-]+)$
Thank you my friend @Raj ! I see what I did wrong now.
I learned something new from you today, really appreciate it.
Best,
Cal
Happy to help
Cheers!!