File field to replace lookup from another file

Hi All,

I don't know how to fast do this field replace that need lookup from another file to form the update result:confused:

I want to do it by general shell script

Can anyone help to solve it ? Thanks for your kindly reply in advance.

CK