Free Trial

Alteryx Designer Desktop Discussions

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

RegEx for email body to parse specific strings

jsamstad
7 - Meteor

Hello! I'm trying to figure out how to parse this email body for these four strings: Vendor Name, Class, AP Balance, and Current Stock? What do I need to use with the Regex tool to extract the proper information? 

 

Thanks in advance!

2 REPLIES 2
MilindG
12 - Quasar
 

You can use text to column tool with the delimiter '\n' and see if that works for you.

jsamstad
7 - Meteor

I'm looking to create columns with each of the fields for analytical purposes. This is just an example of a couple hundred emails I have to go through. Thanks for clarifying my thoughts.

Labels
Top Solution Authors