Shell Programming and Scripting

awk -F"," 'NF != 3 {next}
{
total+=$2;
count+=$3;
print "amount "$1":"$2;
Print "count "$1":"$3;
}
END {
print "total amount :", total;
print "total count :", count;
}' filename

2000.00,23
 0125,1000.00,20
 0124,1000.00,3

amount    0124:1,000.00
amount    0125:1,000.00
 count    0124:3
 count    0125:20
total amount:2,000.00
total count:8

printf "%'.10g\n" 2000
2.000

awk 'BEGIN{FMT="%\047.6g\n"; printf (FMT, 2000)}'
awk: run time error: improper conversion(number 1) in printf("%'.6g
")
    FILENAME="" FNR=0 NR=0

awk -F, 'NF==2  {next}
                {ITM[++c]=$1
                 AMT[c]=$2+0
                 CNT[c]=$3+0
                 TOTA+=$2
                 TOTC+=$3}
         END    {for (i=1;i<=c;i++) print "amount " ITM[i] ":" AMT[i]
                 for (i=1;i<=c;i++) print " count " ITM[i] ":" CNT[i]
                 print "total amount:" TOTA
                 print "total count:" TOTC}
        ' file
amount    0124:1242.35
amount    0125:0
 count    0124:8
 count    0125:0
total amount:1242.35
total count:8

amount    0124:1,242.35
amount    0125:0
 count    0124:8
 count    0125:0
total amount:1,242.35
total count:8

printf "%'.2f" TOTA