Shell Programming and Scripting

Hi Friends,

How i can get the sum of the coloumn value and assign to variable.

Code:

 a1        a2 
233       123
234       345
235       254

i need to get the sum of the to columns and assign to a variable.

Code:

sum1= {.....}
sum2={....}

thanks
Nayanajith.

Code:

awk ' BEGIN { sum1=0; sum2=0}
        { sum1+=$1; sum2+=$2}
        END { printf("%d %d\n", sum1, sum2) } '  filename | read sum1 sum2

Jim,
no need to initialize - all init. is done implicitely

Hi ,

Thanks for the reply.but again i have a little bit problem.

Code:

for i in Gbegamey_A,LC2
do
grep "$i" data.txt > "$i"sort
awk '{sum1+=$17; sum2+=$18} END { printf("%s %d %d %d\n", $i, sum1, sum2, }'  "$i"sort
done

i am trying to print the name ( $i ) infrount of the values , but it is not printing.

ex- Gbegamey_A 234 534
like this.

but it is not putting the name.
234 534 like this.

i need your help to solve this problem.

and secondly how to print the percentage between column and column2

ex . Gbegamey_A 234 534 (234/534)*100

i mean i need this result to ( 234/534)*100=43 to put it to 3 rd column.

ex-
Gbegamey_A 234 534 43


Thanks,
Nayanajith.

Code:

nawk -v num="${i}" '{sum1+=$17; sum2+=$18} END { printf("%s %d %d %d\n", num, sum1, sum2, (sum1/sum2)*100 }' "$i"sort