parse e-mail body from the Outlook connector tool

[chvizda]

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 solution]

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