Shell Programming and Scripting

awk '
  /~YES~/ {Y++}
  /~NO~/{N++}
  END{
    print "Total Records : " NR
    print "YES : " Y
    print "NO : " N
    print "No Response : " NR - Y - N
  }' $(cat filename.txt)

Total Records : 263
YES : 143
NO : 8
No Response : 102

Total Records : 263
YES : 143
NO : 8
No Response : 102
Junk : 10

Junk = Total Records - Yes - No - No Response

Junk = NR - Y - N - (NR - Y - N)

 
while read LINE
do
cat ${LINE}>>count.xls
done < file.txt
print "Total Records : $(awk -F'~' '($1=="99") { sum+=$2 } END { print sum+0 }' count.xls)">>final_count.xls
print "\n">>final_count.xls
print "YES : $(cat count.xls|grep -i '~Y or YES~' | wc -l)">>final_count.xls
print "NO : $(cat count.xls|grep -i '~N or NO~' |wc -l)">>final_count.xls
print "No Response : $(cat count.xls|grep -i '~No Response~' |wc -l)">>final_count.xls
if [ $? -ne 0 ]
then
echo failed
exit 12
fi

print "YES : $(cat count.xls|grep -i '~Y or YES~' | wc -l)

printf "YES:%s\n" "$(cat count.xls | grep "YES~\|~Y " | wc -l)"