Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re^7: HTML Table to MYSQL DB

by choroba (Canon)
on Nov 10, 2011 at 10:31 UTC ( #937323=note: print w/ replies, xml ) Need Help??


in reply to Re^6: HTML Table to MYSQL DB
in thread 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"; } }


Comment on Re^7: HTML Table to MYSQL DB
Download Code
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.
      I do not get it. The information is stored outside TABLE, but you chunk the data on TR.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://937323]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (7)
As of 2015-07-06 10:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (72 votes), past polls