Shell Programming and Scripting

01~12345~Y~YES~aaaaa~can
02~23456~N~NO~bbbbb~can
.
.
.
99~23

1. directory/${LINE}|tail -1|grep -i "99"|cut -d  '~' -f 2
2. directory/${LINE}|grep '~YES~'| wc -l
3. directory/${LINE}|grep '~No~'| wc -l

1.total count : 23  #addition of trailer values for each file '99' suggests it's a trailer
2. YES : 10  # total occurrences of '~YES~' 
3. NO : 5     # total ocurrences of '~NO~'

while read file
do
  awk -F~ '
    {if($1=="99")T=$2; else T=x}
    /~YES~/{Y++}
    /~NO~/{N++}
    END{
       print FILENAME
       print "\t99:" T
       print "\tYES:" Y
       print "\tNO:" N
    }' $file
done< filename.txt

while read file
do
    printf "$file\n\t99: %s\n" $(sed -n '$s/^99~//p' $file)
done < filename.txt

printf "\n\n"

while read file
do
  awk -F~ '
    {if($1=="99")T=$2; else T=x}
    /~YES~/ {Y++}
    /~NO~/{N++}
    END{
       print FILENAME
       print "\tYES:" Y
       print "\tNO:" N
    }' $file
done< filename.txt

while read file
do
    printf "$file\n\t99: %s\n" $(sed -n '$s/^99~//p' $file)
done < filename.txt

printf "\n\n"

while read file
do
  awk -F~ '
    /~YES~/ {Y++}
    /~NO~/{N++}
    END{
       print FILENAME
       print "\tYES:" Y
       print "\tNO:" N
    }' $file
done< filename.txt

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