Lookup on a file

UNIX for Advanced & Expert Users
1

Hi,

I have the following requirement.

I have one lookup file which contains 15 columns and 7000 records.

Ex:

123,MEDICA,134,145,1178,123,678,345,2345,HP,COL,K12,SR,OX,78919

I have input file which contains 14 columns and 20 million records.Some times the record count is more than 20 million.

I need to match the first 14 columns with 14 columns in the lookup file and if matches i need the 15 the column.

Can any one please help me and give me some code which will process very effeciently.
I need to finish this process less than 20 minutes.

Can any one please suggest me how can we acheive this using ksh or even perl script is also good.

Thanks

2

No duplicate or cross-posting, read the rules.

Proceed here:

Thread closed.