We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need help parsing data - RegEx? Text to columns?

John_CMO
7 - Meteor

Have several lines of data where I need to parse out specific pieces of data 

 

Example:

 

Customer PAGE1234 / P AGE LLC Type: Paypal Phone: 123 123-1234

 

I guess I need to be able to configure where the parse starts and stops considering I have several lines of similar data and some names are longer than other. Is there a way to parse this information out into new columns given the character numbers will vary per column? 

 

Thanks

 

13 REPLIES 13
John_CMO
7 - Meteor

Is that the RegEx tool? Or something else?

alexnajm
18 - Pollux
18 - Pollux

it’s my way of testing the pattern that I suggested earlier to see if it pulls out what is necessary - the highlighted portions show that it would parse correctly. Regex101.com

John_CMO
7 - Meteor

Attached a snip of the data 

alexnajm
18 - Pollux
18 - Pollux

I will not help further until Alteryx is attached or actual errors are shown - I have given enough direction and shown proof of it working with the exact example given

Labels
Top Solution Authors