Question

this lab, you will write a shell script, called compare_cols.sh. This program should

• Read a CSV file from standard input (STDIN).
  • Note that in general, CSV files may contain quoted fields with embedded newlines. But for this assignment you can assume that there are no fields with embedded newlines, and therefore each new line represents a new row of the CSV file.
• Print a single number (integer) to standard output (STDOUT): the count of the lines in the CSV file for which the first word occurring in column 3 of the CSV also occurs as a word in column 5 of the CSV.
  • For the purposes of this assignment, words are considered to be sequences of non-space characters delimited on either side by spaces or by the beginning/end of the text string.
  • Whitespace surrounding the integer output will be ignored for scoring.For example, in the following CSV row, the word "six" occurs at the beginning of column 3, and also as a word in column 5:

    one two three,four five,six seven,eight,nine six ten,eleven

Bashscript

Answer 1

Answer) # indicates the comment

echo "Enter the file name"
#read the file from standard input
read fn
#take a counter for line count
c=0
#start the while loop to read every line from the file
while read -r l1
do
#extract the first word of column3 from the line
col3=`echo $l1|cut -d "," -f 3|cut -d " " -f 1`
#extract column5 from the line
col5=`echo $l1|cut -d "," -f 5`
#search col3 from col5
echo $col5|grep $col3 >/dev/null
#check if found then increase c by 1
if test $? -eq 0
then
c=`expr $c + 1`
fi
#loop end and suppy the file name
done < $fn
#display the output of the count
echo $c

Screenshot