How to scrape data from website <td> by <td>

[bambinou]

Hello,

I have never tried this in Zenno and would like to know if you could guide me please.

Here is a demo of the data to scrape:

//FIRST LOT TO SCRAPE
<tr align="Center" bgcolor="#FFFADD" height="20">
<td>XX.XX.XXXX<br>JANUARY</td>
<td>1</td> ///THIS ID CHANGE FOR EACH ROW
<td class="wxy">
<table class="results" border="0">
<tbody>
<tr>
<td>YY1</td>
<td>YY2</td>
<td>YY3</td>
<td>YY4</td>
<td>YY5</td>
<td class="xy"> </td>
<td>YY6</td>
<td>YY7</td>
</tr>
</tbody>
</table>
</td><td>
</td>
</tr>

//SECOND LOT TO SCRAPE
<tr align="Center" bgcolor="#FFFADD" height="20">
<td>XX.XX.XXXX<br>JANUARY</td>
<td>2</td>///THIS ID CHANGE FOR EACH ROW
<td class="wxy">
<table class="results" border="0">
<tbody>
<tr>
<td>YY1</td>
<td>YY2</td>
<td>YY3</td>
<td>YY4</td>
<td>YY5</td>
<td class="xy"> </td>
<td>YY6</td>
<td>YY7</td>
</tr>
</tbody>
</table>
</td><td>
</td>
</tr>

//THIRD LOT TO SCRAPE
<tr align="Center" bgcolor="#FFFADD" height="20">
<td>XX.XX.XXXX<br>JANUARY</td>
<td>3</td>///THIS ID CHANGE FOR EACH ROW
<td class="wxy">
<table class="results" border="0">
<tbody>
<tr>
<td>YY1</td>
<td>YY2</td>
<td>YY3</td>
<td>YY4</td>
<td>YY5</td>
<td class="xy"> </td>
<td>YY6</td>
<td>YY7</td>
</tr>
</tbody>
</table>
</td><td>
</td>
</tr>

I need to scrape the data in the order below, imagine a simple table with rows and their ids each time as:
id | data1|data2|data3|data4|data5|data6|

I need to save the id and data1,data2,data3,data4,data5,data6 to a csv file, I have hundreds of rows to scrape.

Any idea how to do this please? I am not sure how to tell Zenno that "this is row1, this is row2, this is row 3" and so on.


Thanks!

 

[PHaRTnONu]

Text processing page source to list or table? regex it for td's then return all add separator as you see fit?