Parsing/reformatting tables

CobraCards

New Member
Joined
Sep 27, 2006
Messages
1
I need to take some card game spoilers that are formatted like this...

<TABLE align=CENTER cellpadding=0 cellspacing=0><TR><TD COLSPAN=5 BGCOLOR=#0C266B style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;border-top:.5pt solid #000000;"><TABLE ALIGN=CENTER BORDER=0 WIDTH=100%><TR><TD ALIGN=LEFT><FONT COLOR=WHITE>Microsoft Excel - Book2</FONT></TD><TD ALIGN=RIGHT style="font-size:9pt;color:#000000;font-family:caption;color:#ffffff;">___Running: 11.0 : OS = Windows XP </FONT></TD></TR></TABLE></TD></TR><TR><TD BGCOLOR=#D4D0C8 COLSPAN=5 style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;height:25px;"><TABLE BORDER=0 ALIGN=CENTER VALIGN=MIDDLE WIDTH=100%><TR><TD style="font-size:10pt;color:#000000;font-family:caption;">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD ALIGN=RIGHT VALIGN=MIDDLE></TD></TR></TABLE></TD></TR><TR><TD BGCOLOR=WHITE COLSPAN=5 style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;"><TABLE BORDER=0><TR><Form name='formFb202339'><TD ALIGN=CENTER BGCOLOR=White style="width: 60px;"><option value=''>A1</select></TD><TD WIDTH=3% ALIGN=RIGHT BGCOLOR=#D4D0C8 >=</TD><TD ALIGN=LEFT BGCOLOR=White><input type='text' name='txbFb150492' size='80' value='After the Battle'></TD></form></TR></TABLE></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="border-top:.5pt solid #000000;border-left:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;">
</TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>A</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>B</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>C</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>D</CENTER></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>1</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">After the Battle</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>2</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Type</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Mission</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>3</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Symbol</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Earth</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>4</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Entrance Cost</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>5</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Hand Cost</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>6</CENTER></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>7</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Akamaru</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>8</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Type</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Ninja</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>9</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Characteristics</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Leaves Faction</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>10</CENTER></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Ninja Dog</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>11</CENTER></TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Animal</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>12</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Symbol</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Fire</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>13</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Entrance Cost</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>14</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Hand Cost</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">0</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;"> </TD></TR><TR><TD COLSPAN=5 style="border-left:.5pt solid #000000;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;border-top:.5pt solid #808080;;background-color:#D4D0C8;"><TABLE ALIGN=LEFT VALIGN=TOP width=100%><TR><TD ALIGN=LEFT style="border-left:.5pt solid #000000;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;border-top:.5pt solid #808080;background-color: #FFFFFF; width:120pt;"><U>Sheet1</U></TD><TD> </TD></TR></TABLE></TD></TR></TABLE>
<FONT COLOR=#339966 SIZE=1>[HtmlMaker 2.42] </FONT>

... and reformat them like this, for a mySQL database upload:

<CENTER><TABLE align=CENTER cellpadding=0 cellspacing=0><TR><TD COLSPAN=7 BGCOLOR=#0C266B style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;border-top:.5pt solid #000000;"><TABLE ALIGN=CENTER BORDER=0 WIDTH=100%><TR><TD ALIGN=LEFT><FONT COLOR=WHITE>Microsoft Excel - Book2</FONT></TD><TD ALIGN=RIGHT style="font-size:9pt;color:#000000;font-family:caption;color:#ffffff;">___Running: 11.0 : OS = Windows XP </FONT></TD></TR></TABLE></TD></TR><TR><TD BGCOLOR=#D4D0C8 COLSPAN=7 style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;height:25px;"><TABLE BORDER=0 ALIGN=CENTER VALIGN=MIDDLE WIDTH=100%><TR><TD style="font-size:10pt;color:#000000;font-family:caption;">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD ALIGN=RIGHT VALIGN=MIDDLE></TD></TR></TABLE></TD></TR><TR><TD BGCOLOR=WHITE COLSPAN=7 style="border-left:.5pt solid #000000;border-right:.5pt solid #000000;"><TABLE BORDER=0><TR><Form name='formFb543420'><TD ALIGN=CENTER BGCOLOR=White style="width: 60px;"></TD><TD WIDTH=3% ALIGN=RIGHT BGCOLOR=#D4D0C8 >=</TD><TD ALIGN=LEFT BGCOLOR=White><input type='text' name='txbFb965317' size='80' value='Name'></TD></form></TR></TABLE></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="border-top:.5pt solid #000000;border-left:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;">
</TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>A</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>B</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>C</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>D</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>E</CENTER></TD><TD ALIGN=CENTER style="font-size:10pt;color:black;font-family:menu;border-top:.5pt solid #000000;border-right:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>F</CENTER></TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>19</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Name</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Type</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Characteristics</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Symbol</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Entrance Cost</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-top:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">Hand Cost</TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>20</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">After the Battle</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Mission</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;"> </TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Earth</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">2</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">1</TD></TR><TR><TD WIDTH=2% ALIGN=CENTER style="font-size:10pt;color:#000000;font-family:menu;border-top:.5pt solid #000000;border-left:.5pt solid #000000;background-color:#D4D0C8;"><CENTER>21</CENTER></TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-left:.5pt solid #000000;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Akamaru</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Ninja</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Leaves Faction
Ninja Dog
Animal</TD><TD style=" text-align: left; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">Fire</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #D4D0C8;font-size:10pt;font-family:Arial;color:#000000;">1</TD><TD style=" text-align: right; vertical-align: bottom; background-color: #FFFFFF;border-bottom:.5pt solid #D4D0C8;border-right:.5pt solid #000000;font-size:10pt;font-family:Arial;color:#000000;">0</TD></TR><TR><TD COLSPAN=7 style="border-left:.5pt solid #000000;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;border-top:.5pt solid #808080;;background-color:#D4D0C8;"><TABLE ALIGN=LEFT VALIGN=TOP width=100%><TR><TD ALIGN=LEFT style="border-left:.5pt solid #000000;border-bottom:.5pt solid #000000;border-right:.5pt solid #000000;border-top:.5pt solid #808080;background-color: #FFFFFF; width:120pt;"><U>Sheet1</U></TD><TD> </TD></TR></TABLE></TD></TR></TABLE>
<FONT COLOR=#339966 SIZE=1>[HtmlMaker 2.42] </FONT></center>

So to analyze this a bit, the first output column (arbitrarily called "Name") is filled in with the header for each "section" -- that is, the first cell in Column A after a blank line. The other contents of Column A generate the rest of the output columns, and the contents of Column B are used to fill in the table.

When the info in Column B is spread over more than one row (as in "Leaves Faction" "Ninja Dog" "Animal" above), it is put into a single cell but separated with an HTML line break for later use.

Simple enough for a human... but with thousands of these things to convert, I need some sort of automated system. Is it possible to set something up like this in Excel? :D

Thanks in advance!
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,141,226
Messages
5,705,130
Members
421,379
Latest member
SoundlessResonance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top