Need help RegEx Parse

[elclark]

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.

[fmvizcaino · Accepted 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

[Thableaus]

Hi @elclark 

Try the REGEX tool on Parse mode.

(\w+)/(\w+)\s?(\w*)

Cheers,

[elclark]

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?

[Thableaus · Accepted solution]

@elclark 

(\w+)\s?/(\w+)\s?(\w*)

This should work with the space as well.

Cheers,