Parse email .msg to extract out data tables
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Parse
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
