How to know there is something in the cell or not ?
- by Harikrishna
I have table like below in the html file:
<table border="1">
<tr>
<td>BuyQuantity</td><td>SellQuantity</td>
</tr>
<tr>
<td>15D</td><td> <span style="font-family: "Arial Unicode MS";"><o:p></o:p></span></p></td>
</tr>
<tr>
<td> <span style="font-family: "Arial Unicode MS";"><o:p></o:p></span></td><td>38D</td>
</tr>
<tr>
<td> <span style="font-family: "Arial Unicode MS";"><o:p></o:p></span></td><td>99D</td>
</tr>
<tr>
<td>38D</td><td> <span style="font-family: "Arial Unicode MS";"><o:p></o:p></span></td>
</tr>
</table>
There are two columns: buy-quantity and sell-quantity.(It is only example but in each html file there is different content in the table.) Now with the content of these two columns I want to decide there is items bought or items sold.Like in the first row there is 15d buy-qauntity then items were bought and in the second row there is 38d sell-qauntity then items were sold and so on. And after deciding there is items-bought or items-sold I want to build one column named buy/sell for this table like below:
![alt text][1]
[1]: http://C:\Documents and Settings\Administrator\My Documents\My Pictures\untitled.png
How can I do this ?