Search Results

try:
awk 'NR==FNR{a[$1]=$1;b[$2]=$2;c[$1$2]=$0;next} ($1 in a) && ( $2 in b ) { print c[$1$2],$3}' FileA FileB

I am sure this can be optimized.

Hello all,

first of all, thank you very much for your help. In order to print A1, A2, A3 (first three columns from FileA), B3 (third column from File B), I have tried to edit the script modified...

You are right, sorry!
In fact the output will be A1,A2,A3,B3
Thanks a lot for your hel, I appreciate!

Hello all,

I'm a quite absolute beginner on awk and I will appreciate any help to solve the following problem.

I have two different files, each of these with three columns.
File A (A1, A2,...