Shell Programming and Scripting

Hi,

I am trying to read 2 files and writing to the 3rd file if I find the same elements in 2 files. my first file is

1 0 kb12124819 766409 1.586e-01
1 0 kb17160939 773886 8.674e-01
1 0 kb4475691 836671 8.142e-01
1 0 kb28705211 890368 6.189e-01
1 0 kb13303118 908247 7.252e-01
1 0 kb9777703 918699 1.263e-01
1 0 kb3121567 933331 6.866e-02

my 2nd file is:

kb12124819 1
kb17160939 1
kb4475691 3
kb28705211 3
kb13303118 2
kb9777703 2
kb3121567 4


if $3 of my first file == $1 of my 2nd file, I would like to print:

$1, $4 from first file and $2 from 2nd file.

Could you please help me to do this? How can I read the two files simulatenously?

Thanks in advance.

Kind regards,
Ezhil

Code:

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

Regards

Thank a lot, Franklin. It works fine.

Thanks again,
Ezhil