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