![]() |
|
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 |
| Splitting input files into multiple files through AWK command | arund_01 | Shell Programming and Scripting | 3 | 05-13-2008 10:17 AM |
| Find duplicates from multuple files with 2 diff types of files | ricky007 | Shell Programming and Scripting | 2 | 03-04-2008 01:46 PM |
| unzip particular gzip files among the normal data files | thepurple | Shell Programming and Scripting | 4 | 11-30-2007 11: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 04:20 AM |
| text files, ASCII files, binary files and ftp transfers | Perderabo | Answers to Frequently Asked Questions | 0 | 04-08-2004 05:25 PM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
||||
|
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 11:53 AM.. |
|
||||
|
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 11:59 AM.. Reason: Changed the logic slightly |
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|