Need help RegEx Parse

Question

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 Answer

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 · Accepted Answer

@elclark

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

This should work with the space as well.

Cheers,