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!
You can use text to column tool with the delimiter '\n' and see if that works for you.
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.