Shell Programming and Scripting

Hi Guys,

I need to write a script to compare the count of two csv files each having 5 columns.
Everyday a csv file is recived.
Now we need to compare the count of todays csv file with yesterday's csv file and if the total count of records is same in todays csv file and yesterday csv file out will be all good else it should display the difference of the counts.
For eg:1-jan-2013 CSV file has 200 records
2-jan-2013 CSV file has 201 records.
o/p will be "difference of 1 record" else o/p "is all good"

Code:

#!/bin/ksh
TODAY_FILE=file1.txt
YESTERDAY_FILE=file2.txt
TF_LC=$(wc -l $TODAY_FILE|awk '{print $1}')
YF_LC=$(wc -l $YESTERDAY_FILE|awk '{print $1}')
DIFF=$(expr $TF_LC - $YF_LC)
if [ $DIFF -eq 0 ]
then
 echo "is all good"
else
 echo "difference of ${DIFF} record(s)"
fi

Perfect.thanks a lot..

You may try this also awk solution

Code:

awk 'FNR==NR{c=NR;next}END{print (c==FNR)?"\nAll Good\n":"\nDifference of\t" c-FNR "\trecords\n"}'  today.csv   yesterday.csv