RegEx for email body to parse specific strings
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jsamstad
7 - Meteor
‎08-08-2023
11:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Labels:
- Labels:
- Preparation
- Transformation
2 REPLIES 2
MilindG
12 - Quasar
‎08-08-2023
11:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use text to column tool with the delimiter '\n' and see if that works for you.
‎08-08-2023
11:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.