SOLVED
parse e-mail body from the Outlook connector tool
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
chvizda
8 - Asteroid
‎03-26-2018
04:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all
I use the Outlook connector to get e-mails. The data I need are in the Body of the e-mail.
How can I parse this email to get the data which are in the table marked red
I see the data, of the body in the "unique body" field with "new lines" detected.
I assume the can be parsed.
Many thanks in advance Steffen
Solved! Go to Solution.
Labels:
- Labels:
- Tips and Tricks
- Workflow
1 REPLY 1
BenMoss
ACE Emeritus
‎03-26-2018
04:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
First of all, recordID each email response.
Secondly use the 'text to columns' tool but configure it to be 'split to rows', you can then set the delimiter as /n (new line) and you will then get a row for every line within your email.
Hopefully this then makes your table visible; you may need more parsing after this but it should put you in a good position.
Ben