Hello,
I'm new to using RegEx and I'm trying to Parse a name field. The names are formatted as follows
Smith/John A
Doe/Jane
I tried using the below expression but it's not parsing any of the fields, I just get a message saying 0 records were successfully parsed and 100 were not.
(\d+)\W(\d+)\s(\d+)
Any help would be much appreciated.
Thanks.
Solved! Go to Solution.
Hi @elclark ,
Attached is an example showing how to get that done.
You can use both regex or text to columns to accomplish what you need, I have created both examples for you.
Take a look and let me know if that works for you.
Best,
Fernando Vizcaino
Thank you! One quick follow up, a couple of the records did not parse because the name was formatted differently, there was a space after the last name, as follows
Smith /John
What changes would i need to make to capture both scenarios with a space or no space before or after the / symbol?