|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Advanced & Expert Users Expert-to-Expert. Learn advanced UNIX, UNIX commands, Linux, Operating Systems, System Administration, Programming, Shell, Shell Scripts, Solaris, Linux, HP-UX, AIX, OS X, BSD. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| duplicate rows in a file | infyanurag | Shell Programming and Scripting | 3 | 05-22-2008 01:39 AM |
| Using Sed to duplicate a section of a file.... | nick26 | Shell Programming and Scripting | 2 | 05-01-2008 12:18 PM |
| How to obtain system open file table value in Linux | mahesh. | Shell Programming and Scripting | 0 | 05-25-2007 11:25 AM |
| arrow keys / special keys | raguramtgr | UNIX for Dummies Questions & Answers | 3 | 02-20-2004 02:45 AM |
| Get a none duplicate list file | trynew | Shell Programming and Scripting | 5 | 06-25-2002 01:06 AM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
07-27-2007
|
||||
|
||||
|
obtain duplicate keys in csv file
Hi,
having two csv files, both sorted, by key (column1), f1 containing duplicate keys and f2 containing no duplicate keys, how can I obtain all rows from f1 with the keys listed in file2? Example: f1 is: k1,gsj01fd k2,vi982cj k2,1fjk01e k3,81kjfds k4,sd9dasi f2 is: k2 k3 and I would like to obtain f3 like: k2,vi982cj k2,1fjk01e k3,81kjfds Thanks. |
|
07-27-2007
|
||||
|
||||
|
Code:
awk -F"," 'BEGIN{ while ((getline < "f2" ) > 0 ) arr2[i++]=$0 } { for ( x in arr2 ) { if ( match(arr2[x], $1) ) { print; last } } }' f1
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
