parse e-mail body from the Outlook connector tool

Question

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

BenMoss · Accepted Answer

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