|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| getting particular text after grep from lookup file | napolayan | UNIX for Dummies Questions & Answers | 10 | 10-20-2006 11:52 AM |
| Lookup with a file | pavan_test | UNIX for Dummies Questions & Answers | 5 | 07-21-2006 11:57 AM |
| reverse lookup file problem | Westy564 | IP Networking | 2 | 01-09-2004 02:55 PM |
| file lookup | gillbates | UNIX for Dummies Questions & Answers | 6 | 12-12-2003 02:04 PM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
08-30-2007
|
||||
|
||||
|
file Lookup using awk
Hi All,
I have two files file1 and file2(lookup file).I need to map more than one keyfields of file1 with file2.how can we achieve it using awk. file1(max 2.2 million records) -------------------------- 680720|680721|077 680720|680721|978 680721|680722|090 file2(no idea about the record count) --------------------------------------- 680721|A|680720 680722|B|680721 Assumptions: 1)file 2 will not have any duplicate records. 2)no idea about the number of records. Keyfields:1,2 for file1 and 3,1 for file2 Output --------- 680720|680721|077|A 680720|680721|978|A 680721|680722|090|B Please help me how to go about. I can try with arrays but as file2 record is not fixed, i cant take in array.please suggest me. regards, sukumar |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
