Parse email .msg to extract out data tables

[AP-89]

Hi folks,

I have a use case where there's about 600 emails with standard data tables in them, goal would be to have Alteryx read each one and pull the data out if it exists in that weekly email and make one data table. Originally they are created in .msg format (see attached screenshot). We haven't found a good way to parse through these email messages, if anyone knows how to do that happy to learn!

For my second question, attaching the .txt file converted from .msg, looking to parse the data table out of the attached text file. See attached screenshot of the file uploaded in Alteryx as fixed width. I am looking for quick suggestions on how to easily parse through the data and I would appreciate the community's help. Thank you!

[AP-89]

Hi All, 

I have an update on this request, Actually there are 209 files tha tneed parsing and they do not have same structure but it's still intercompany errors. If anyone has any idea on parsing the combined data I can scrub and attach it here. Thanks!

[Dean4U]

Hi @AP-89,

Thanks for sharing your update with us. You can parse the message body’s table data with the Regex Tool (if it’s structured text or HTML) or Text To Columns / Multi-Row Formula(for more straightforward tab-delimited data).

From what I understand, you will probably need a combo of the Regex tool with the Text to Column tool(or the Multi-Row tool), as well as the Transpose tool or the Cross-tab tool. Below is a similar use case we were able to locate that may guide you in your work:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Parsing-RegEx-and-Transformati...

Below is the link to a guide Megan has prepared. I would advise you to refer to it in case you need more help with Parsing:

https://community.alteryx.com/t5/Alteryx-Community-Resources/Text-Parsing-Guide/ta-p/1040190

Hope this helps you out.

Take care.

[KGT]

Also, your text looks rather structured there. So don't go too funky before exploring whether you can actually match the format, rather than "find the data" for each field. The above guides are gold for working through the myriad of cases this could be.

If you can't find a delimiter (\t or similar), then my solution on this page MAY help if each field is a set length:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Importing-TXT-delimited-by-com...

Once you've figured out one, you should be able to apply that to the others.

These 2 posts that are related but different stages, may also assist when you get to applying it to multiple files. But get one right first!

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Data-Cleansing-Fields-arrange/...

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Data-Cleansing-Arranging-of-fi...