Unix Command to get the count of lines in a csv file

Question

Hi I am new to UNIX and I have to get the count of lines from incoming csv files. I have used the following command to get the count.

wc -l filename.csv 

Consider files coming with 1 record iam getting some files with * at the start and for those files if i issue the same command iam getting count as 0. Does * mean anything in here and if i get a file with ctrlm(CR) instead of NL how to get the count of lines in that file. gimme a command that solves the issue. Thanks in advance.

Answer 1

The following query helps you to get the count

cat FILE_NAME  | wc -l 

Answer 2

All of the answers are wrong. CSV files accept line breaks in between quotes which should still be considered part of the same line. If you have either Python or PHP on your machine, you could be doing something like this:

Python

//From stdin cat *.csv | python -c "import csv; import sys; print(sum(1 for i in csv.reader(sys.stdin)))"  //From file name python -c "import csv; print(sum(1 for i in csv.reader(open('csv.csv'))))" 

PHP

//From stdin cat *.csv | php -r 'for($i=0; fgetcsv(STDIN); $i++);echo "$i\n";'  //From file name php -r 'for($i=0, $fp=fopen("csv.csv", "r"); fgetcsv($fp); $i++);echo "$i\n";' 

I have also created a script to simulate the output of wc -l: https://github.com/dhulke/CSVCount