Shell Programming and Scripting

Dear all,

I have two files like below.

file1
======

x y
==== ===
123 test1
124 test2
125 test3

file2
=======

a b c
=== === ====
123 361123 662661
1021 1222530 5960577
125 598097 1094666
27073 1309791 5797483
124 278967 4424643

if the "a" column of file2 matching with "x" column of file1
so i want to replace "a" column value of file2 with the "y" column of the file1s .


like below,

a b c
=== === ====
test1 361123 662661
1021 1222530 5960577
test3 598097 1094666
27073 1309791 5797483
test2 278967 4424643

please help to do it.

Thanks you.

Code:

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

Regards

Code:

awk 'NR==FNR{_[$1]=$2;next}$1 in _{$1=_[$1]}1' file1 file2

Use nawk or /usr/xpg4/bin/awk on Solaris.