Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
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
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.
      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 romping around the Monastery: (18)
As of 2015-07-31 17:59 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 (280 votes), past polls