|
|
|
|||||||
| Home | Forums | Register | Rules & FAQ | Members List | Arcade | 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 here. Shell Script Page. |
Other UNIX.COM Threads You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Splitting input files into multiple files through AWK command | arund_01 | Shell Programming and Scripting | 3 | 05-13-2008 06:17 AM |
| Find duplicates from multuple files with 2 diff types of files | ricky007 | Shell Programming and Scripting | 2 | 03-04-2008 09:46 AM |
| unzip particular gzip files among the normal data files | thepurple | Shell Programming and Scripting | 4 | 11-30-2007 07:17 AM |
| when I try to run rm on multiple files I have problem to delete files with space | umen | UNIX for Dummies Questions & Answers | 1 | 09-20-2005 12:20 AM |
| text files, ASCII files, binary files and ftp transfers | Perderabo | Answers to Frequently Asked Questions | 0 | 04-08-2004 01:25 PM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Search this Thread | Display Modes |
05-14-2008
|
|||
|
|||
|
Files
I have two files:
file1.txt l l 0 s s 0 a a 0 a b 0 a c 0 a d 0 a e 0 file2.txt a a 1 a b 2 a c 3 a d 4 Both this two files have 3 colums. The file1 will have blank records and the file 2 will have values but just for some combinations. I need to created an file3.txt that will have a blank record in case the file2 don’t have a value for that combination. File3.txt l l 0 s s 0 a a 1 a b 2 a c 3 a d 4 a e 4 Can anyone help me in developing this in shell script? Thanks Last edited by mkw : 05-14-2008 at 07:53 AM. 
|
| Forum Sponsor | ||
|
|
|
05-14-2008
|
|||
|
|||
|
This is a FAQ, search the forums for NR==FNR
Code:
awk 'NR==FNR { b[$1 $2] = $3 ; next }
{ if (b[$1 $2]) $3 = b[$1 $2]; print }' file2.txt file1.txt
Last edited by era : 05-14-2008 at 07:59 AM. Reason: Changed the logic slightly
|
|||
| Google UNIX.COM |
Linear Mode
