Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: How check whether csv file with header is empty file or not in perl

by bart (Canon)
on Sep 06, 2012 at 10:26 UTC ( #992057=note: print w/ replies, xml ) Need Help??


in reply to How check whether csv file with header is empty file or not in perl

Let me edit your code...

open(my $data, '<', $file_c) or die "Could not open '$file_c' $!\n"; my $rows = 0; while (my $line = <$data>) { next if ($. == 1); chomp $line; my @fields = split "," , $line or next; $rows++; print"$fields[0] fields[1]"; } print "Total: $rows rows.\n" if $rows; print "No rows were found.n" unless $rows;


Comment on Re: How check whether csv file with header is empty file or not in perl
Download Code
Re^2: How check whether csv file with header is empty file or not in perl
by hi123 (Initiate) on Sep 06, 2012 at 10:44 UTC
    Thanks bart!!!!
Re^2: How check whether csv file with header is empty file or not in perl
by Tux (Monsignor) on Sep 06, 2012 at 14:03 UTC

    Let me edit your code, which is very unsafe once the CSV gets a little bit more complicated ...

    use Text::CSV_XS; my $csv = Text::CSV_XS->new ({ binary => 1, auto_diag => 1 }); open my $data, "<", $file_c or die "$file_c: $!\n"; my $rows = 0; while (my $row = $csv->getline ($data)) { $rows++; } print "Total $rows rows (including header line)\n";

    Though I'd probably go to an even simpler solution using DBD::CSV:

    $ ll xx.csv 12862169 -rw-rw-rw- 1 merijn users 415423 Sep 6 16:00 xx.csv $ perl -MDBI -wE'say DBI->connect("dbi:CSV:f_ext=.csv")->selectrow_arr +ayref("select count(*) from xx")->[0]," rows in fs"' 8739 rows in fs

    Enjoy, Have FUN! H.Merijn

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (8)
As of 2014-09-02 22:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (31 votes), past polls