bash - Calculating the sum of every third column from many files -


i have many files 3 columns in form of:

 file1 | file2  1 0 1  | 1 0 2  2 3 3  | 2 3 7  3 6 2  | 3 6 0  4 1 0  | 4 1 3  5 2 4  | 5 2 1 

first 2 columns same in each file. want calculate sum of 3 columns every file receive this:

1 0 3  2 3 10  3 6 2  4 1 3  5 2 5 

for 2 files awk 'fnr==nr { _a[fnr]=$3;} nr!=fnr { $3 += _a[fnr]; print; }' file* work (i found solution via google). how change on many files?

since first 2 columns same in each file:

awk 'nr==fnr{b[fnr]=$1 fs $2;}{a[fnr]+=$3}end{for(i=1;i<=length(a);i++){print b[i] fs a[i];}}' file* 

array a used have cumulative sum of 3rd column of files. array b used 1st , 2nd column values in end, print contents of array a , b


Comments

Popular posts from this blog

node.js - Node js - Trying to send POST request, but it is not loading javascript content -

javascript - Replicate keyboard event with html button -

javascript - Web audio api 5.1 surround example not working in firefox -