You’re offline. This is a read only version of the page.
Announcements
6
Hi Team,
I have an html file in my email body which contains 6 tables . i want to read the data from all the tables in a csv file.
below is the sample html file.
<html><head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><meta name=\"Generator\" content=\"Microsoft Word 15 (filtered medium)\"><style>\r\n<!--\r\n@font-face\r\n\t{font-family:Helvetica}\r\n@font-face\r\n\t{font-family:\"Cambria Math\"}\r\n@font-face\r\n\t{font-family:Calibri}\r\np.MsoNormal, li.MsoNormal, div.MsoNormal\r\n\t{margin:0in;\r\n\tfont-size:11.0pt;\r\n\tfont-family:\"Calibri\",sans-serif}\r\na:link, span.MsoHyperlink\r\n\t{color:blue;\r\n\ttext-decoration:underline}\r\n.MsoChpDefault\r\n\t{font-size:10.0pt}\r\n@page WordSection1\r\n\t{margin:1.0in 1.0in 1.0in 1.0in}\r\ndiv.WordSection1\r\n\t{}\r\n-->\r\n</style></head><body lang=\"EN-US\" link=\"blue\" vlink=\"purple\" style=\"word-wrap:break-word\"><div class=\"WordSection1\"><table class=\"MsoNormalTable\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\" width=\"100%\" style=\"width:100.0%\"><tbody><tr><td style=\"padding:.75pt .75pt .75pt .75pt\"><p class=\"MsoNormal\"><img width=\"59\" height=\"35\" src=\"" align=\"right\" hspace=\"4\" vspace=\"4\" alt=\"Description: awslogo\" style=\"width:.6111in; height:.3611in\"><span style=\"font-size:10.0pt\"></span></p></td></tr><tr><td style=\"padding:.75pt .75pt .75pt .75pt\"><div style=\"border:none; border-top:solid #FFC000 6.0pt; padding:0in 0in 0in 0in\"><p align=\"center\" style=\"margin-right:0in; margin-bottom:4.5pt; margin-left:0in; text-align:center\"><span style=\"font-size:1.0pt; font-family:"Helvetica",sans-serif\"> </span></p></div></td></tr></tbody>",
"><p class=\"MsoNormal\"> </p><table class=\"MsoNormalTable\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\" width=\"100%\" style=\"width:100.0%\"><tbody><tr><td style=\"padding:.75pt .75pt .75pt .75pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif\">AWS Budget Notification </span></p></td><td style=\"padding:.75pt .75pt .75pt .75pt\"><p class=\"MsoNormal\" align=\"right\" style=\"text-align:right\"><span style=\"font-family:"Helvetica",sans-serif\">August 01, 2023 </span></p></td></tr><tr><td style=\"padding:.75pt .75pt .75pt .75pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif\">AWS Account <i>12345678</i> </span></p></td><td style=\"padding:.75pt .75pt .75pt .75pt\"></td></tr></tbody>",
"><p class=\"MsoNormal\"> </p><table class=\"MsoNormalTable\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\" width=\"100%\" style=\"width:100.0%\"><tbody><tr><td style=\"padding:.75pt .75pt .75pt .75pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif\">Dear AWS Customer, </span></p></td></tr></tbody>",
"><p class=\"MsoNormal\"> </p><table class=\"MsoNormalTable\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\" width=\"100%\" style=\"width:100.0%\"><tbody><tr><td style=\"padding:.75pt .75pt .75pt .75pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif\">You requested that we alert you when the <b>forecasted cost</b> associated with your <i>Budget</i> budget <b>exceeds $212.86</b> for the current month. The month <b>forecasted cost</b> associated with this budget is <b>$285.83</b>. You can find additional details below and by accessing the AWS Budgets dashboard. </span></p></td></tr></tbody>",
"><p class=\"MsoNormal\"> </p><table class=\"MsoNormalTable\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" style=\"max-width:600.0pt; border-collapse:collapse\"><tbody><tr><td style=\"border:solid #CCCCCC 1.0pt; background:#CCCCCC; padding:3.75pt 7.5pt 3.75pt 7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif; color:black\">Budget Name </span><span style=\"font-family:"Helvetica",sans-serif\"></span></p></td><td style=\"border:solid #CCCCCC 1.0pt; border-left:none; background:#CCCCCC; padding:3.75pt 7.5pt 3.75pt 7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif; color:black\">Budget Type </span><span style=\"font-family:"Helvetica",sans-serif\"></span></p></td><td style=\"border:solid #CCCCCC 1.0pt; border-left:none; background:#CCCCCC; padding:3.75pt 7.5pt 3.75pt 7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif; color:black\">Budgeted Amount </span><span style=\"font-family:"Helvetica",sans-serif\"></span></p></td><td style=\"border:solid #CCCCCC 1.0pt; border-left:none; background:#CCCCCC; padding:3.75pt 7.5pt 3.75pt 7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif; color:black\">Alert Type </span><span style=\"font-family:"Helvetica",sans-serif\"></span></p></td><td style=\"border:solid #CCCCCC 1.0pt; border-left:none; background:#CCCCCC; padding:3.75pt 7.5pt 3.75pt 7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif; color:black\">Alert Threshold </span><span style=\"font-family:"Helvetica",sans-serif\"></span></p></td><td style=\"border:solid #CCCCCC 1.0pt; border-left:none; background:#CCCCCC; padding:3.75pt 7.5pt 3.75pt 7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif; color:black\">FORECASTED Amount </span><span style=\"font-family:"Helvetica",sans-serif\"></span></p></td></tr><tr style=\"height:7.5pt\"><td style=\"border:solid #CCCCCC 1.0pt; border-top:none; padding:7.5pt 7.5pt 7.5pt 7.5pt; height:7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif\">Budget </span></p></td><td style=\"border-top:none; border-left:none; border-bottom:solid #CCCCCC 1.0pt; border-right:solid #CCCCCC 1.0pt; padding:7.5pt 7.5pt 7.5pt 7.5pt; height:7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif\">Cost </span></p></td><td style=\"border-top:none; border-left:none; border-bottom:solid #CCCCCC 1.0pt; border-right:solid #CCCCCC 1.0pt; padding:7.5pt 7.5pt 7.5pt 7.5pt; height:7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif\">$212.86 </span></p></td><td style=\"border-top:none; border-left:none; border-bottom:solid #CCCCCC 1.0pt; border-right:solid #CCCCCC 1.0pt; padding:7.5pt 7.5pt 7.5pt 7.5pt; height:7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif\">FORECASTED </span></p></td><td style=\"border-top:none; border-left:none; border-bottom:solid #CCCCCC 1.0pt; border-right:solid #CCCCCC 1.0pt; padding:7.5pt 7.5pt 7.5pt 7.5pt; height:7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif\">> $212.86 </span></p></td><td style=\"border-top:none; border-left:none; border-bottom:solid #CCCCCC 1.0pt; border-right:solid #CCCCCC 1.0pt; padding:7.5pt 7.5pt 7.5pt 7.5pt; height:7.5pt\"><p class=\"MsoNormal\"><span style=\"font-family:"Helvetica",sans-serif\">$285.83 </span></p></td></tr></tbody>",
"><p class=\"MsoNormal\"> </p><table class=\"MsoNormalTable\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"height:12.5pt\"><td width=\"280\" style=\"width:210.0pt; background:#1166BB; padding:0in 0in 0in 0in; height:12.5pt; -webkit-border-radius:5px; -moz-border-radius:5px; border-radius:5px\"><p class=\"MsoNormal\" align=\"center\" style=\"text-align:center\"><span style=\"font-family:"Helvetica",sans-serif; color:white\"><a href=\"www.powerapps.com"><span style=\"color:white; text-decoration:none\">Go to the AWS Budgets dashboard </span></a></span></p></td></tr></tbody>
Share
Report
All responses (
Answers (
