rajeshi1980
New Member
- Joined
- May 9, 2013
- Messages
- 14
Hi,
Have the below code in HTML format, and wanted to extract them in to excel columns separately. have 100s of records such in one excel column for now. please help...
"""
<h4>Specifications</h4>
<table class=""table table-striped"">
<tbody>
<tr>
<td>Color</td>
<td>Black</td>
</tr>
<tr>
<td>Memory</td>
<td>32 GB</td>
</tr>
<tr>
<td>Weight</td>
<td>192 g</td>
</tr>
<tr>
<td>Display</td>
<td>5.4 inch</td>
</tr>
<tr>
<td>Camera</td>
<td>18 MP</td>
</tr>
<tr>
<td>OS</td>
<td>Android OS, v5.1.1 (Lollipop)</td>
</tr>
<tr>
<td>Sim Card</td>
<td>Nano-SIM</td>
</tr>
<tr>
<td>Key pad</td>
<td>QWERTY</td>
</tr>
<tr>
<td>Screen</td>
<td>Corning Gorilla Glass 4 & Curved edge screen</td>
</tr>
<tr>
<td>Features</td>
<td>CPU is Dual-core 1.8 GHz Cortex-A57 & quad-core 1.44 GHz Cortex-A53, Active noise cancellation with dedicated mic, Non-removable Li-Ion 3410 mAh battery and Capacitive touch 4-row BlackBerry keyboard.</td>
</tr>
</tbody>
</table>
"""
Have the below code in HTML format, and wanted to extract them in to excel columns separately. have 100s of records such in one excel column for now. please help...
"""
<h4>Specifications</h4>
<table class=""table table-striped"">
<tbody>
<tr>
<td>Color</td>
<td>Black</td>
</tr>
<tr>
<td>Memory</td>
<td>32 GB</td>
</tr>
<tr>
<td>Weight</td>
<td>192 g</td>
</tr>
<tr>
<td>Display</td>
<td>5.4 inch</td>
</tr>
<tr>
<td>Camera</td>
<td>18 MP</td>
</tr>
<tr>
<td>OS</td>
<td>Android OS, v5.1.1 (Lollipop)</td>
</tr>
<tr>
<td>Sim Card</td>
<td>Nano-SIM</td>
</tr>
<tr>
<td>Key pad</td>
<td>QWERTY</td>
</tr>
<tr>
<td>Screen</td>
<td>Corning Gorilla Glass 4 & Curved edge screen</td>
</tr>
<tr>
<td>Features</td>
<td>CPU is Dual-core 1.8 GHz Cortex-A57 & quad-core 1.44 GHz Cortex-A53, Active noise cancellation with dedicated mic, Non-removable Li-Ion 3410 mAh battery and Capacitive touch 4-row BlackBerry keyboard.</td>
</tr>
</tbody>
</table>
"""