Re^7: HTML Table to MYSQL DB

You are overcomplicating it. Why all the opening and chunking?


use warnings;
use strict;

use HTML::TableExtract;

my $te = HTML::TableExtract->new();
$te->parse_file('935413.html');


foreach my $ts ($te->tables) {
    foreach my $row ($te->rows) {
        print join(',', @$row),"\n";
    }
}
[download]

Comment on Re^7: HTML Table to MYSQL DB Download Code

Replies are listed 'Best First'.
Re^8: HTML Table to MYSQL DB by Fiddler (Initiate) on Nov 10, 2011 at 13:50 UTC
I know chroba but, You see i need to create a time-stamp column with some data outside of the html tables. so with each chunk of data, that variable will change depending on the stamp... ( see original table to get an idea of what i'm saying). Chunks are the only thing i can think about to get that info.	[reply]
Re^9: HTML Table to MYSQL DB by choroba (Cardinal) on Nov 10, 2011 at 22:17 UTC
I do not get it. The information is stored outside TABLE, but you chunk the data on TR.	[reply]