read .csv file

Shell Programming and Scripting
1

Need UNIX script read below .csv file and print the line only records where type = TRN.

Srno,Type,InputFileName,NewColumnData
1,TRN,File1.dat,11
2,TRN,File2.dat,12
3,TRN,File3.dat,13
4,REF,File4.dat,
5,REF,File5.dat,

regards,
santosh

2 
awk -F, '$2=="TRN"' file.csv
3 
$ ruby -ne 'print if $_["TRN"]' file
4

Here is the ksh script code,

while read line
do
Type=`echo $file | cut -d "," -f 2`
if [ $Type == "TRN" ]; then
 echo $line
done < $input_file
5 
grep TRN infile.csv