Shell Programming and Scripting

 
checksum.out
customer_information_
product_information_
sales_information_
due_information_
 
 
Trailer_Data.csv
5,4,0,3,20001010,1000
14,2,0,0,20001010,2000

 
 
echo "\n-----------------------------------------------------------------------------------------------------" >> Validation_Count_Match.out
echo "File Name\tAtcual value\tGenrated value\tDifference\tFile status" >> Validation_Count_Match.out
echo "-----------------------------------------------------------------------------------------------------\n" >> Validation_Count_Match.out
 
for i in 1 2 3 4 5
while read file; do
filename=$file"Detail"
if [ -e $TargetDir/$filename.csv ]
then
Actual=`awk -F"," '{x += $i} END {print x}' i=$i Trailer_Data.csv`
Generated=`wc -l $filename.csv |awk -F" " '{print $1}'`
echo $filename"\t: " $Actual"\t:"$Generated"\t" `expr $Actual - $Generated`"\tPresent" >> Validation_Count_Match.out
else
Actual=`awk -F"," '{x += $i} END {print x}' i=$i Trailer_Data.csv`
echo $filename"\t:"$Actual"\t:0\t"`expr $Actual - 0`"\tNot Present">> Validation_Count_Match.out
fi
done <checksum.out
done

 
Output
-----------------------------------------------------------------------------------------------------
File Name------------------------Atcual value-----Genrated value-----Difference-----File status
-----------------------------------------------------------------------------------------------------
 
customer_information_Detail 19 19 0 Present
product_information_Detail 6 6 0 Present
sales_information_Detail 0 0 0 Not present
due_information_Detail 3 3 0 Present