Re: Lookup between 2 files ( korn shell )

From: pawan_test <sridhara007_at_gmail.com>
Date: 30 Jan 2006 06:06:02 -0800
Message-ID: <1138629962.847049.30040@g49g2000cwa.googlegroups.com>

Hi ALL.,

THANKS for all your responses.
 it seems to be working if the DS.txt is in this format ALBD:xxxxx
FLN:yyyyyyy
WLG:ttttttt

i am getting the desired output i.e
OSC :ALBD: 377
OSC :ALBD :378
OSC: ALBD: 379

FLN :FLN: 140
FLN :FLN :141
WLG :WLG :243

WLG: WLG: 244
WLG :WLG: 245
WLG :WLG :246
MAT: WLG :247 but when i modified the DS.txt as;

ALBD:xxxxx

FLN:yyyyyyy
GIE:ttttttt ( here there is no match)
WLG:ttttttt

then the desired output is getting repeated twice..result.txt is;

OSC :ALBD: 377
OSC :ALBD :378
OSC: ALBD: 379

FLN :FLN: 140
FLN :FLN :141
WLG :WLG :243

WLG: WLG: 244
WLG :WLG: 245

WLG :WLG :246
MAT: WLG :247
OSC :ALBD: 377

OSC :ALBD :378
OSC: ALBD: 379

FLN :FLN: 140
FLN :FLN :141
WLG :WLG :243

WLG: WLG: 244
WLG :WLG: 245
WLG :WLG :246
MAT: WLG :247 the code that i tried is;
for item in `cat $FILE1 | awk -F: '{print $1}'` do
grep -w $item $FILE2 >>result_file.txt
done

can anyone please give me a suggestion;

thanks
pavi Received on Mon Jan 30 2006 - 08:06:02 CST