Monday 29 December 2008

sum of all values of a column

Summation of all values from 2nd to 6th field in a file with fields seperated by a space delimiter :

for i in `seq 2 6`; do awk ' $1 !~ /Name/ {sum+=$"'"$i"'"} END {print "field" "'"$i"'",")",sum}' data.out ;done

Here is out data.out :

Name salary incomtax pf hra allowance

sachin 4000 400 200 400 100
dhoni 5000 500 200 400 100


No comments:

Post a Comment

Tweets by @sriramperumalla