Shell Programming and Scripting

Code:

ail,UTT,id1_0,COMBO,21,24,21,19
al,UTHAST,id1_0,COMBO,342,390,361,361
dmo,UTST,id1_0,COMBO,21,15,22,23
vne,UAST,id1_0,COMBO,345,372,390,393

awk -F, '{sum+=$5+$6+$7+$8} END {print sum}' infile
3120

awk -F, '{ sum=0; for (i=5;i<=NF;i++) sum+=$i; print sum}'

awk -F, '{if(NF>max) max=NF;hsum=0;for(i=start;i<=NF;i++){vsum[i]+=$i;hsum+=$i}
print "Horizontal sum for row " NR " : " hsum}
END{for(i=start;i<=max;i++) print "Vertical sum for column " i " : " vsum[i]}' start=5 OFMT='%.2f' file

Code:

op,plac,ids,plan,dt1,dt2,dt3,dt4,total


ail,UTT,id1_0,COMBO,21,24,21,19,85
al,UTHAST,id1_0,COMBO,342,390,361,361,1454
dmo,UTST,id1_0,COMBO,21,15,22,23,81
vne,UAST,id1_0,COMBO,345,372,390,393,1500


total                           1500,729,801,794,796,3120

awk -F, '{C5+=$5; C6+=$6; C7+=$7; C8+=$8; R=$5+$6+$7+$8} {print $0","R}  END {print "total",R","C5","C6","C7","C8","C5+C6+C7+C8}'
ail,UTT,id1_0,COMBO,21,24,21,19,85
al,UTHAST,id1_0,COMBO,342,390,361,361,1454
dmo,UTST,id1_0,COMBO,21,15,22,23,81
vne,UAST,id1_0,COMBO,345,372,390,393,1500
total 1500,729,801,794,796,3120