in reply to difficulty reading csv file
Then you could also use perl to download/fetch the file using LWP::Simple. Then use Encode to decode the content. After that, use Text::CSV_XS (or Text::CSV) to parse the decoded data.
# untested, just an example use strict; use warnings; use autodie; use LWP::Simple; use Text::CSV_XS; my $data = get ("http://some.web.site/location/data.csv"); open my $fh, "<", \$data; # if the site correctly encoded the data open my $fh, "<:encoding(utf-8)", \$data; # if you have to decode your +self my $csv = Text::CSV_XS->new ({ auto_diag => 1, binary => 1 }); while (my $row = $csv->getline ($fh)) { # do something with @$row }
Again, a link to the original data would be a nice pointer to people here that want to help you out.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: difficulty reading csv file
by foxycleop (Initiate) on Aug 08, 2011 at 21:43 UTC | |
by Tux (Canon) on Aug 08, 2011 at 23:41 UTC |