UNIX for Dummies Questions & Answers

$ cat test.csv
*,None Pack,1003036,Curr Emp Ref Request Quote No 2,2,2
 ,None Pack,1003036,Curr Emp Ref Request Quote No 2,8,2
 ,None Pack,1003036,Curr Emp Ref Request Quote No 2,99,6
*,None Pack,1004345,KFI Chase Quote No 1,2,2
*,None Pack,1006148,KFI Chase Quote No 1,1,1
*,None Pack,1004979,Curr Emp Ref Request Quote No 1,2,2
*,None Pack,1003031,Curr Emp Ref Request Quote No 3,2,2
*,None Pack,1003030,Curr Emp Ref Request Quote No 2,4,4
*,None Pack,1003037,Curr Acc Ref Request Quote No 2,3,3
*,None Pack,1004820,Curr Acc Ref Request Quote No 1,3,3
*,None Pack,1003037,Curr Emp Ref Request Quote No 2,7,7
*,None Pack,1003030,Curr Emp Ref Request Quote No 2,4,4
$

$ cat test.csv
None Pack,1003036,Curr Emp Ref Request Quote No 2,109,10
None Pack,1004345,KFI Chase Quote No 1,2,2
None Pack,1006148,KFI Chase Quote No 1,1,1
None Pack,1004979,Curr Emp Ref Request Quote No 1,2,2
None Pack,1003031,Curr Emp Ref Request Quote No 3,2,2
None Pack,1003030,Curr Emp Ref Request Quote No 2,4,4
None Pack,1003037,Curr Acc Ref Request Quote No 2,3,3
None Pack,1004820,Curr Acc Ref Request Quote No 1,3,3
None Pack,1003037,Curr Emp Ref Request Quote No 2,7,7
None Pack,1003030,Curr Emp Ref Request Quote No 2,4,4
$

 
#!/bin/ksh
cat test.csv | while read LINE; do
col1=$(echo $LINE | awk -F, '{print $1}')
stream_id=$(echo $LINE|awk -F, '{print $2}')
doc_type=$(echo $LINE|awk -F, '{print $4}')
no_of_sheets=$(echo $LINE|awk -F, '{print $5}')
no_of_images=$(echo $LINE|awk -F, '{print $6}')
if [ "$col1" = "*" ] ; then
    total_no_sheets=$no_of_sheets
    total_no_images=$no_of_images
    echo ${stream_id},${doc_type},${total_no_sheets},${total_no_images} >> file1
else
    total_no_sheets=`expr ${total_no_sheets} + ${no_of_sheets}`
    total_no_images=`expr ${total_no_images} + ${no_of_images}`
    echo ${stream_id},${doc_type},${total_no_sheets},${total_no_images} >> file2
fi
    echo "${stream_id},${doc_type},${total_no_sheets},${total_no_images}" >> file3
done

# cat xx.awk
function dumpline ()
{
   for (i=2;i<=linesize;i++) {
      if (i > 2) {
         printf ("%s",FS);
      }
      printf ("%s",currline[i]);
   }
   printf ("\n");
}
$1 ~ /*/ {
   if (NR != 1) {
      dumpline();
   }
   linesize=split ($0, currline);
}
$1 !~ /*/ {
   currline[5]=currline[5]+$5
   currline[6]=currline[6]+$6
}
END {
   dumpline();
}
# awk -F, -f xx.awk test.csv
None Pack,1003036,Curr Emp Ref Request Quote No 2,109,10
None Pack,1004345,KFI Chase Quote No 1,2,2
None Pack,1006148,KFI Chase Quote No 1,1,1
None Pack,1004979,Curr Emp Ref Request Quote No 1,2,2
None Pack,1003031,Curr Emp Ref Request Quote No 3,2,2
None Pack,1003030,Curr Emp Ref Request Quote No 2,4,4
None Pack,1003037,Curr Acc Ref Request Quote No 2,3,3
None Pack,1004820,Curr Acc Ref Request Quote No 1,3,3
None Pack,1003037,Curr Emp Ref Request Quote No 2,7,7
None Pack,1003030,Curr Emp Ref Request Quote No 2,4,4

$ awk -F, -f test.awk test.csv
awk: 0602-521 There is a regular expression error.
        *?+ not preceded by valid expression
 The source line number is 12.
 The error context is
                $1 ~ /*/ >>>  { <<<
$