REGEX Match Help

[caltang]

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

[Raj · Accepted solution]

does this help 

[caltang]

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?

[Raj · Accepted solution]

^(\d+).([A-Za-z\s'-]+), ([A-Za-z\s'-]+)$

[caltang]

Thank you my friend @Raj ! I see what I did wrong now. 

I learned something new from you today, really appreciate it.

Best,

Cal

[Raj]

Happy to help

Cheers!!