[Solved] Mathematical operation in multiple files

Shell Programming and Scripting
1

Hi experts,
I need to do a mathematical calculation between each data in 3 different files. Output is using formula (A11+B11)/(1+C11).

INPUT :

File A.txt

A11 A12 
A21 A22

File B.txt

B11 B12
B21 B22

File C.txt

C11 C12
C21 C22

OUTPUT:

(A11+B11)/(1+C11)  (A12+B12)/(1+C12)
(A21+B21)/(1+C21)  (A22+B22)/(1+C22)

Thank you for the help.

2

nawk -f guns.awk A.txt B.txt C.txt
guns.awk:

FNR==1{f++}
{
  for(i=1;i<=NF;i++)
    file[f,FNR,i]=$i
  fnr=FNR
  nf=NF
}
END{
  for(i=1;i<=fnr;i++)
    for(j=1;j<=nf;j++)
      printf("%.2f%c", (file[1,i,j]+file[2,i,j])/(1+file[3,i,j]), (j==nf)?ORS:OFS)
}
1 Like
3

Working perfectly. Thank you very much.

4 
paste A.txt B.txt C.txt |awk '{print ($1+$3)/$5, ($2+$4)/$6}'
2 Likes