Shell Programming and Scripting

{ read line
  while read line; do
    do stuff
  done
} < infile

for file in "$INPUT_FILE_FOLDER/"AA_BB_CC*.CSV
  do
     echo ${file##*/}
     TYPE=`echo ${file##*/} | cut -d "_" -f 4`
     echo "Type is $TYPE"

            line=`head -1 $file`
	#echo "Line is : $line"
	nrfields=$(IFS=\;; set -- $line; echo $#)
	if [ $nrfields -ne 4 ]; then
	   echo "Incorrect HEADER record fields"
	else
               Date=`echo $line | cut -d ";" -f 2`
	   echo "Date is : $Date"
	   FileType=`echo $line | cut -d ";" -f 4`
	   echo "File Type is $FileType"
	fi
	
	if [ $TYPE == $FileType ]; then
	   echo "Header record is correct"
               // TO DO : read from 2nd line onwards
              // check 7th field of line
              // if its "1" then get 2nd and 4th filed values in array / variables
             // insert array value and Date value into DB table

for file in "$INPUT_FILE_FOLDER/"AA_BB_CC*.CSV
do
{ IFS=\; read x date x filetype x
  if [ -z "$filetype" ]; then
    echo "Incorrect HEADER record fields"
    exit 1
  fi
  echo "Date is : $date"
  echo "File Type is $filetype"
  while IFS=\; read x var2 x var4 x x var7 x
  do
    if [ $var7 -eq 1 ]; then
      echo insertintable $var2 $var4
    fi
  done
} < "$file"
done

Date is : 20100913115432
File Type is NO
insertintable AAA DDD
insertintable CCC DDD