Hello All, I've a unix script th

[toronto2003]

Hello All,

I've a unix script that runs as a cron job to look for three *.csv files on a particular machine, do a record count in the *.csv files and report it via email.

Currently even if there are no records in the *.csv files, it reports are record count=1. How can i take off this header information. If there are no records in the csv files, it should report as '0'.

Any help on this would be highly appreciated.

Thanks!

 

[Ygor]

To get the record count, subtract 1 from the line count, i.e....

#----Bourne shell
countA=`wc -l <fileA.csv`
countA=`expr $countA - 1`

#----Korn shell
(( countA = $(wc -l < fileA.csv) - 1 ))

echo record count for fileA is $countA

 

[toronto2003]

Hello Ygor,

Thanks for your help and reply back.

In my script the echo statement reporting the count is

echo &quot;File $my_dir/$i present with $(cat $i|wc -l) records.&quot;

Where and how should i embedd the

(( countA = $(wc -l < fileA.csv) - 1 ))

Please help

Thanks!

 

[Ygor]

echo &quot;File $my_dir/$i present with $(( $(wc -l < $i) - 1 )) records.&quot;