help with add


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting help with add
# 1  
Old 12-17-2008
help with add

Code:
$ cat file
x A 10 20 30
x B 5 10 12
x C 10 4 5
x D 10 3 6
x K 10 23 4
x M 5 7 0

Req o/p:

Code:
x A 15 30 42
x C 20 7 11
x K 15 30 4

Basically I want to add up 2 rows values as above.


I can sum the whole rows

Code:
$ awk '
{ for (i=3;i<=NF;++i) sum[i]+=$i; j=NF}
END {for (i=3;i<=j;++i) printf "%s%s",OFS,sum[i]}' file

 50 67 57

Please help to add two rows values as I mentioned in my req o/p above, thanks.
# 2  
Old 12-17-2008
nawk -f uwork.awk myFile

uwork.awk:
Code:
!(FNR % 2) {
     printf("%s%s%s%s", f2[1], OFS, f2[2], OFS);
     for (i=3; i<=NF;i++)
        printf("%d%c", $i + f2[i], (i==NF) ? RS : FS)
     split("", f2)
     next
}
{
  split($0, f2)
}

Login or Register to Ask a Question

Previous Thread | Next Thread

1 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to add add some files together and then paste

How can you efficiently add pairs of files together and then paste those pairs, I have a climate computer at work which spits out temperatures and stuff out twice a day, one for the day-data and one for the night (basically). Every week I want to make a nice overview The text files are... (1 Reply)
Discussion started by: uwgandalf
1 Replies
Login or Register to Ask a Question