Pages

Monday, August 1, 2011

Summing column values using AWK

if you have value like this

$cat juned.txt
juned_workers 0.03322
juned_workers 0
juned_workers 0.17053
juned_workers 0
juned_workers 0.41322
juned_workers 0
juned_workers 0.16864
juned_workers 0.05603
juned_workers 0
juned_workers 0.15836

and if you want the total of column 2 , awk will be handy

$cat juned.txt | awk '{print "Row"NR,$_} { s += $2 } END { print "Total : ", s} '
Row1 juned_workers 0.03322
Row2 juned_workers 0
Row3 juned_workers 0.17053
Row4 juned_workers 0
Row5 juned_workers 0.41322
Row6 juned_workers 0
Row7 juned_workers 0.16864
Row8 juned_workers 0.05603
Row9 juned_workers 0
Row10 juned_workers 0.15836
Total : 1

No comments:

Post a Comment