Re: 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;
[download]

Comment on Re: How check whether csv file with header is empty file or not in perl Download Code

Replies are listed 'Best First'.
Re^2: How check whether csv file with header is empty file or not in perl by Tux (Canon) 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";` [download] 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` [download] Enjoy, Have FUN! H.Merijn	[reply] [d/l] [select]
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!!!!	[reply]