I have scraped an html table with as many as 100 rows with 5 columns. Practically everything I have been trying treats the entire table as one variable. For instance, I'm able to write the table to a file.
What I want to be able to do is loop through each row, one by one and explode out the row to 5 variables: cell1, cell2, cell3, cell4, cell5.
I then want to use these (while still remaining in the loop for this row) in a SQL query:
INSERT INTO db_table (col1, col2, col3, col4, col5) VALUES ('cell1', 'cell2', 'cell3', 'cell4', 'cell5')
Seems very simple but I can't quite make this happen in Ubot. How do you break up (or explode) table rows out into variables like that?