awk 求每列的和

suphone

有文件abc.lst为：
44230001|6,694.90|565,883.26|-559,188.36|0.00|0.00|0.00|0.00|0.00|0.00|0.00
44230002|83,225.62|532,546.84|-449,321.22|0.00|0.00|0.00|0.00|0.00|0.00|0.00
44230003|29,383.31|684,084.83|-654,701.52|0.00|0.00|0.00|0.00|0.00|0.00|0.00
44230004|15,900.91|325,823.49|-309,922.58|0.00|0.00|0.00|0.00|0.00|0.00|0.00
44230005|1,010.00|231,069.80|-230,059.80|0.00|0.00|0.00|0.00|0.00|0.00|0.00
求$2，$3,$4……，$11每列的和，第一个域显示为“和为”
即：和为|sum2|sum3|sum4|……|sum11
求助各位高手。

li2002

1. 
   
2. sed 's/,//g' abc.lst|awk -F\| '{for(i=2;i<=NF;i++)s[i]+=$i}END{printf("和为");for(i=2;i<=NF;i++)printf("|%.2f",s[i]);printf("\n")}'
   

复制代码

和为|136214.74|2339408.22|-2203193.48|0.00|0.00|0.00|0.00|0.00|0.00|0.00

suphone

我试过了，ok，很好用，非常感谢！！！