How to Parse/Read HTML table data from email body
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-09-2022 11:16 AM
Hi
I want to read html data table from email inbound and insert data into the table, please suggest.
My table has this format.
<head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii"> <meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style><!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; font-size:11.0pt; font-family:"Calibri",sans-serif;} span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;} .MsoChpDefault {mso-style-type:export-only; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} @page WordSection1 {size:612.0pt 792.0pt; margin:72.0pt 72.0pt 72.0pt 72.0pt;} div.WordSection1 {page:WordSection1;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1" /> </o:shapelayout></xml><![endif]--> </head> <body lang="EN-IN" link="#0563C1" vlink="#954F72" style="word-wrap:break-word"> <div class="WordSection1"> <table class="MsoNormalTable" border="1" cellspacing="3" cellpadding="0"> <tbody> <tr> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal" align="center" style="text-align:center"><b>Trigger By <o:p> </o:p></b></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal" align="center" style="text-align:center"><b>Request ID <o:p> </o:p></b></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal" align="center" style="text-align:center"><b>Question ID <o:p> </o:p></b></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal" align="center" style="text-align:center"><b>Question <o:p></o:p></b></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal" align="center" style="text-align:center"><b>Answer <o:p></o:p></b></p> </td> </tr> <tr> <td style="padding:.75pt .75pt .75pt .75pt"></td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">REQ0001067<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">QVUL0001014<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">How are you?<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">[ fine ]<o:p></o:p></p> </td> </tr> <tr> <td style="padding:.75pt .75pt .75pt .75pt"></td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">REQ0001067<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">QVUL0001001<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">How to create Group in Microsoft team?<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">[ navigator ]<o:p></o:p></p> </td> </tr> <tr> <td style="padding:.75pt .75pt .75pt .75pt"></td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">REQ0001067<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">QVUL0001012<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">Why Microsoft team not working?<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">[ network issue ]<o:p></o:p></p> </td> </tr> <tr> <td style="padding:.75pt .75pt .75pt .75pt"></td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">REQ0001067<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">QVUL0001013<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">what is Apps in microsoft team?<o:p></o:p></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal">[ app store ]<o:p></o:p></p> </td> </tr> </tbody> </table> <p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> </div> . </body> </html>
Thanks
Pradeep sharma
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-09-2022 02:23 PM
Hi, your post does not make your requirements clear. What exactly are you trying to parse\how do you intend to use the results?
The easiest way to parse the data could be via the plain text version of the body IE email.body_text, using basic java-script string methods.
https://www.w3schools.com/js/js_string_methods.asp
