Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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