Parsing multiple items from string

Hi,

I'm trying to find a way to take the dependents names out of this block of text:

Doe, John - coverage was changed on [date] , new coverage effective [date] Doe, John - (Employee) coverage Added Doe, Jane - (Spouse) coverage Added Doe, Jill - (Child) coverage Added Doe, Jack- (Child) coverage Added Doe, Jackie - (Child) coverage Added

I need to take the names of the children and spouse and make them separate items. I've been trying to use regex to do this but I'm still a bit new and i'm not sure how to best do this. Any ideas?

Workflow

Regex

Parse

Help

Accepted answers

Hey @ltensmeyer,

Here is one way:

You can parse the employee with this regex:

(.*?) -

Gets everything before the first space and dash.

Then tokenise to rows and get dependent and relation in a column together:

coverage Added (.*?)\)

This gets everything between coverage added and the next curvy bracket.

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20Data

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

All comments

Hey @ltensmeyer,

Just so I can understand the problem a bit better could you give an example of what you would expect the outcome to be in table format?

This is the final result I'm looking for. The important part is just separating each individual into a new row.

Hey @ltensmeyer,

Here is one way:

You can parse the employee with this regex:

(.*?) -

Gets everything before the first space and dash.

Then tokenise to rows and get dependent and relation in a column together:

coverage Added (.*?)\)

This gets everything between coverage added and the next curvy bracket.

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20Data

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

This worked perfectly. Thank you so much for your help!

No worries @ltensmeyer! have a good one 😄

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703