|
|
|
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 |
| join two files | koti_rama | Shell Programming and Scripting | 5 | 08-05-2008 05:20 AM |
| Join two files | koti_rama | Shell Programming and Scripting | 4 | 06-10-2008 07:15 AM |
| Join columns from 2 files | osramos | Shell Programming and Scripting | 2 | 11-14-2007 05:25 AM |
| how to join files | jxh461 | UNIX for Dummies Questions & Answers | 5 | 08-23-2007 08:11 AM |
| Join Files | choppas | Shell Programming and Scripting | 2 | 10-18-2006 11:03 AM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
03-15-2007
|
||||
|
||||
|
join files
Hi ,
I want to join 2 files based on 2 column join condition. a11 john 2230 5000 a12 XXX 2230 A B 200 345 Expected O/P John 2230 5000 A B 200 I have tried this awk 'NR==FNR{a[$2]=$1;next}a[$2]&&sub($1,a[$2])' a11 a12 > a13 john 2230 A B 200 345 Thannksinadvance Mohan |
|
03-15-2007
|
||||
|
||||
|
Code:
awk 'NR==FNR{a[$2]=$0;next}a[$2]&&sub($1,a[$2])&&sub($(NF - 4), "")' a11 a12
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
