Shell Programming and Scripting

CE2DD,N,5055,16.12.2013,3.114,12195.89,MVR,003388,Web::00000005055,Web Payment

for var_amt_pay in `awk -F',' '{ arr[$1","$5","$8] += $6} END {for (i in arr) {print i "," arr[i] } }' tp.txt`
do
             
    code=`echo $var_amt_pay | awk -F',' '{ print $1 }'`
    cust=`echo $var_amt_pay | awk -F',' '{ print $2 }'`
    num=`echo $var_amt_pay | awk -F',' '{ print $3 }'`
    amt=`echo $var_amt_pay | awk -F',' '{ print $4 }'`
       
   echo "amt is :"$amt

$ echo "CE2DD,N,5055,16.12.2013,3.114,12195.89,MVR,003388,Web::00000005055,Web Payment" | \
awk -F',' '{ arr[$1","$5","$8] += $6} END {for (i in arr) print i "," sprintf("%5.2f",arr[i])  }'
CE2DD,3.114,003388,12195.89

$ echo "CE2DD,N,5055,16.12.2013,3.114,12195.89,MVR,003388,Web::00000005055,Web Payment" | \
awk -F',' '{ arr[$1","$5","$8] += $6} END {for (i in arr) print i "," arr[i]}' CONVFMT="%5.2f"
CE2DD,3.114,003388,12195.89

awk -F, '
        BEGIN {
                CONVFMT = "%.2f"
        }
        {
                A[$1 FS $5 FS $8] += $6
        }
        END {
                for ( k in A )
                {
                        split ( k, R )
                        print "Code: " R[1]
                        print "Cust: " R[2]
                        print "Nume: " R[3]
                        print "Amnt: " A[k]
                }
        }
' tp.txt