This is a discussion on match the columns of 2 files and merge common rows within the Shell scripting forums, part of the Development/Scripting category; there are 2 tab-delimited files a.txt 10 abc 1234 20 def 4356 30 ghi 6789 b.txt 1 20 2 10 ...
|
|||||||
| Register | FAQ | Members List | Calendar | Forgotten your password? | Mark Forums Read |
|
|||
|
there are 2 tab-delimited files
a.txt 10 abc 1234 20 def 4356 30 ghi 6789 b.txt 1 20 2 10 Now i want to compare column 1 of a.txt wid column 2 of b.txt and if both match I wil merge the matching rows into output file Output shud be 20 def 4356 1 10 abc 1234 2 or 1 20 def 4356 2 10 abc 1234 |
| Sponsored Links | ||
|
|
![]() |
| Bookmarks |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to match two fields | Prahlad | Shell scripting | 3 | 04-09-2008 01:58 PM |
| diff command to exclude files that match pattern | piggy | Getting started tutorials | 1 | 08-13-2007 11:52 PM |
| Select specific rows | c341 | Shell scripting | 6 | 01-18-2007 03:04 AM |
| Mysql how to specify select columns | raj | Databases servers | 2 | 12-19-2006 02:23 AM |
| help me in editing this columns | sureshbup | Shell scripting | 1 | 12-12-2006 03:29 PM |