From: pauld <[EMAIL PROTECTED]>
> ive read a load of data in from a CSV file with Text::CSV and ended
> up with a hash (%hash) where the keys are the column labels.
> my @headings=split(/,/,$rows[0])
> and then
>
> for (my $j=1;$j<$#rows;$j++)
> {
> my $status = $csv->parse ($rows[$j]); # parse a CSV string into
> fields
> my @columns = $csv->fields (); # get the parsed fields
>
> for (my $i=0;$i<$#columns;$i++)
> {$hash{$headings[$i]}=$columns[$i];}
>
> I want to process the data once its grouped by the date field present
> in $hash.
Maybe your task would be easier if you used DBI and DBD::CSV and use
SQL to group the data the way you need them instead of loading the
raw data and "hand-processing" them.
Jenda
===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz =====
When it comes to wine, women and song, wizards are allowed
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
