关于awk求和的问题，急！！！

postyw

我在用awk求一列数的和时，数字中间有“，”分隔，怎样正确求出结果
例如： 9,100.34
          1,999.00
          5,656.55
怎样解决？

lhyonly

sed 's/,//' abc

chang_311

参考一下：
awk '{while ($0~ /,/) {$0=substr($0,1,index($0,","-1)substr($0,index($0,","+1)} print $0}' aa.txt

随风漂

awk '{gsub(",","",$0);sum+=$0;}END{print sum}' filename

bjgirl

1. awk '{gsub(/,/,"")}{sum+=$0}END{printf "%.2f\n",sum}' file

复制代码

wxytty

awk -F"," 'BEGIN {SUM+=$2} END {print SUM}' infile

邵林寺

cat | awk -F"," {SUM+=$2}END{printf("%.2f\n",SUM)}

c1l2d3

如果在将计算得到的结果按每三位在加上逗号就更完美了:

1. awk '{gsub(/,/,"")}{sum+=$0}END{printf "%.2f\n",sum}' file\
   
2. |awk -F"." '{OFS="."}{if($2=="")$2="00";$1="00"$1;m="";\
   
3. for(i=3;i<=length($1);i+=3)m=","substr($1,length($1)-i+1,3)m;print m,$2}'\
   
4. |sed 's/^\(,\)\(0\{0,\}\)//'

复制代码