in reply to Storing table data in a (simulated) multidimensional array
If the file or URL contains more than one table, you can pass HTML::TableExtract values defining the number or headings via the AnyData modules to specify which table you want.#!perl -w use strict use AnyData; my $table = adTie( 'HTMLtable', $filename_url_or_string); while (my $row = each %$table) { printf "%s : %s\n", $row->{user},$row->{city}; } or ... #!perl -w use strict; use DBI; my $dbh=DBI->connect('dbi:AnyData:'); $dbh->ad_catalog( 'Test','HTMLtable', $filename_url_or string); print $dbh->selectrow_array('SELECT city FROM Test WHERE user = ?',und +ef,'Fred Bloggs');
|
|---|