Shell Programming and Scripting

I am developing shell script on Linux OS and I have two files.Data in each file is like :

File1 :

Code:

A    B   C 
E     F    G 
X   Y    Z

File 2:

Code:

A  C  12 
E  G  22
X  Z  41

I need if first and third column entries ( $1 & $3) of File1 in same row matches with first & second column entries ($1 & $2) of File 2 in same row , Then whatsoever is in next column of File 2 (For eg. 12 , 22 , 41 as above) should join as 4th column of File 1.

In the above problem the desired output needed is :

A B C 12
E F G 22
X Y Z 41

Code:

awk 'NR==FNR{a[$1$3]=$0;next}{print a[$1$2],$3;}' file1 file2

Guru.

with join

Code:

join -1 3 -2 2 -o "1.1 1.2 2.2 2.3" file1 file2

Sorry, this only looks at the 3rd field in file1 and the 2nd field in file2. Not what the OP wanted.

Thanks Guru , It worked.