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!
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,108,631
Messages
5,523,992
Members
409,554
Latest member
denistrevisan

This Week's Hot Topics

Top