Shell Programming and Scripting

Dear Folks,
If I have 2 files, say A and B in format:

A:

$1 $2
01032 12856
01041 13351
01042 11071
01042 12854
01042 12862
01042 12866
.
.
.

and

B:

$3 $4
01031 123
01032 412
01041 441
01042 321
01043 224
.
.
.

The problem is, I want to take the $4 value for each entity in $2. $3 and $2 is the same, the only different is $3 is sorted and $2 unsorted.
The output should be in this format:

$2 $4


with $2 is in original form.


($n is the field numbering).

How to do that ?

Thanks in advance.

nawk -f a.awk file1 file2

a.awk:

Code:

FNR==NR { a[$1]=$2; next }
$1 in a { print a[$1], $2 }

Thanks bro, it works!