cancel
Showing results for 
Search instead for 
Did you mean: 

How to parse Email body

yajjala1
Participant
0 Kudos
160

My sender mail looks like

I received some thing like

<Content><html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:tax="http://schemas.microsoft.com/sharepoint/taxonomy/soap/" xmlns:tns="http://schemas.microsoft.com/sharepoint/soap/recordsrepository/" xmlns:spsup="http://microsoft.com/webservices/SharePointPortalServer/UserProfileService" xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="Generator" content="Microsoft Word 14 (filtered medium)"> <style><!-- /* Font Definitions */ @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; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} h1 {mso-style-priority:9; mso-style-link:"Heading 1 Char"; margin:1.5pt; font-size:18.0pt; font-family:"Times New Roman","serif"; color:#8DA22F; font-weight:bold;} h2 {mso-style-priority:9; mso-style-link:"Heading 2 Char"; margin:1.5pt; text-align:center; font-size:18.0pt; font-family:"Times New Roman","serif"; font-weight:bold;} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; font-size:12.0pt; font-family:"Times New Roman","serif";} span.Heading1Char {mso-style-name:"Heading 1 Char"; mso-style-priority:9; mso-style-link:"Heading 1"; font-family:"Cambria","serif"; color:#365F91; mso-fareast-language:EN-CA; font-weight:bold;} span.Heading2Char {mso-style-name:"Heading 2 Char"; mso-style-priority:9; mso-style-link:"Heading 2"; font-family:"Cambria","serif"; color:#4F81BD; mso-fareast-language:EN-CA; font-weight:bold;} p.tdamount, li.tdamount, div.tdamount {mso-style-name:td_amount; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; text-align:right; font-size:12.0pt; font-family:"Times New Roman","serif";} p.halftable, li.halftable, div.halftable {mso-style-name:halftable; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; font-size:12.0pt; font-family:"Times New Roman","serif";} p.label, li.label, div.label {mso-style-name:label; mso-margin-top-alt:auto; margin-right:11.25pt; mso-margin-bottom-alt:auto; margin-left:3.75pt; text-align:right; font-size:12.0pt; font-family:"Times New Roman","serif"; font-weight:bold;} p.colleft, li.colleft, div.colleft {mso-style-name:colleft; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; font-size:12.0pt; font-family:"Times New Roman","serif";} p.colright, li.colright, div.colright {mso-style-name:colright; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; font-size:12.0pt; font-family:"Times New Roman","serif";} p.colleft50, li.colleft50, div.colleft50 {mso-style-name:colleft50; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; font-size:12.0pt; font-family:"Times New Roman","serif";} p.colright50, li.colright50, div.colright50 {mso-style-name:colright50; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; font-size:12.0pt; font-family:"Times New Roman","serif";} p.colclear, li.colclear, div.colclear {mso-style-name:colclear; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; font-size:12.0pt; font-family:"Times New Roman","serif";} p.errortext, li.errortext, div.errortext {mso-style-name:errortext; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; font-size:12.0pt; font-family:"Times New Roman","serif"; color:red; font-weight:bold;} p.errorbox, li.errorbox, div.errorbox {mso-style-name:errorbox; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; background:#FFBABA; font-size:12.0pt; font-family:"Times New Roman","serif"; color:#D8000C; display:none; font-weight:bold;} p.td1bgtop, li.td1bgtop, div.td1bgtop {mso-style-name:td1_bg_top; mso-margin-top-alt:auto; margin-right:0cm; margin-bottom:11.25pt; margin-left:3.75pt; background:#D3DBA9; font-size:12.0pt; font-family:"Times New Roman","serif";} p.td1bgbottom, li.td1bgbottom, div.td1bgbottom {mso-style-name:td1_bg_bottom; margin-top:11.25pt; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; background:#D3DBA9; font-size:12.0pt; font-family:"Times New Roman","serif";} p.td2bg, li.td2bg, div.td2bg {mso-style-name:td2_bg; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; background:#463014; font-size:10.0pt; font-family:"Times New Roman","serif"; color:#E3E3E3; font-weight:bold;} p.itemhead, li.itemhead, div.itemhead {mso-style-name:item_head; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; text-align:center; background:#E3E3E3; font-size:8.0pt; font-family:"Times New Roman","serif"; color:#131313; font-weight:bold;} p.itembodyamount, li.itembodyamount, div.itembodyamount {mso-style-name:item_body_amount; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; text-align:right; font-size:12.0pt; font-family:"Times New Roman","serif";} p.itemtotals, li.itemtotals, div.itemtotals {mso-style-name:item_totals; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; text-align:right; background:#E3E3E3; font-size:8.0pt; font-family:"Times New Roman","serif"; color:#131313; font-weight:bold;} p.adddesc, li.adddesc, div.adddesc {mso-style-name:add_desc; mso-margin-top-alt:auto; margin-right:0cm; mso-margin-bottom-alt:auto; margin-left:3.75pt; text-align:right; font-size:12.0pt; font-family:"Times New Roman","serif";

I need like this file

Merchant # Batch # Order ID Product Code 1 (Cob Invoice #) Item Amount 1 Product Code 2 Item Amount 2 Transaction Total Settlement Date Transaction Date Txn Time Cardholder # Card Type 30205598669 913 mhp 18078005230p26 17-02585 $105.00 non-refundable $1.84 $106.84 20/03/2018 19/03/2018 09:54pm 4510****7100 Visa

Accepted Solutions (0)

Answers (0)