Need help parsing data - RegEx? Text to columns?

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

Regex

Accepted answers

alexnajm

I can’t help any further without screenshots of what you are actually doing in the configuration - or just attach the workflow itself. The code worked for me

All comments

alexnajm

Regex is your best bet! You can use the Parse method to define patterns that follow what you need. Based on what you have (assuming Customer, Type, and Phone will always be there and the spacing/punctuation will be consistent), this should work.

Customer\s(.+)\sType:\s(.+)\sPhone:\s(.+)

John_CMO

The spacing will not be consistent considering length of customer name will vary. Will this still work?

alexnajm

By spacing I mean the number of spaces, not the position

Please try the solution and come back with any concerns sample data would also be beneficial

John_CMO

It populates the columns but did not successfully parse.

alexnajm

You aren’t really giving me much to work with… please provide your sample data and your expected output. From the above, it looks like you wanted to parse out anything after those labels so that is what’s reflected

John_CMO

The example above is what I am trying to parse. Each item in red text should be in separate columns (So 4 columns in total).

Page1234 - Customer Code

Page LLC - Customer Number (So everything after the "/" to the word "Type")

Paypal - Method of payment

123 123-1234 - Phone number

alexnajm

Then adjust the Regex accordingly

Customer\s(.+)\s\/\s(.+)\sType:\s(.+)\sPhone:\s(.+)

John_CMO

It's creating the columns in the output but not parsing the data. Do I need to update any parameters in the RegEx tool?

alexnajm

I can’t help any further without screenshots of what you are actually doing in the configuration - or just attach the workflow itself. The code worked for me

John_CMO

Is that the RegEx tool? Or something else?

alexnajm

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

Attached a snip of the data

alexnajm

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

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335