UNIX for Dummies Questions & Answers

Hello

Thanks guys for your suggestions;

FILE1=/home/pavi/DS.txt
FILE2=/home/pavi/chain.txt

awk -F ":" '{print $1}' $FILE1 > f1.txt
awk -F " " '{print $2}' $FILE2 > f2.txt


DS.txt contains;

ALBD:xxxxx
FLN:yyyyyyy
WLG:ttttttt

chain.txt contain;

ECK: ECK: 331
ECK: ECK: 336
FED :FED :427
FIE :FIE: 212
FLN :FLN: 140
FLN :FLN :141
FMF: FMF: 183
FR1 :FR1: 303
FTT :FTT :423
GAT :GAT: 185
GEN :GEN: 396
GFY :GFY: 268
GIA :GIA: 228
GMD :GMD: 264
MIN: MIN: 158
MRO :MRO: 354
MY0 :MY0: 315
NCS :NCS: 390
OSC :ALBD: 377
OSC :ALBD :378
OSC: ALBD: 379
OSC ALBD 380
WLG :WLG :243
WLG: WLG: 244
WLG :WLG: 245
WLG :WLG :246
MAT: WLG :247

the result.txt has to look like this;


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 script has to match the 1st column from DS.txt with the 2nd column of chain.txt and only those that matched, move all the corresponding 1st , 2nd and 3rd columns of chain.txt to a output file say result.txt

this is what i am trying to accomplish.

can anyone please help me ..

tx
pavi

Here you do

#!/bin/sh

for item in `cat file_1|awk -F: '{print $1}'`
do
grep -w $item file_2 >>result_file
done

Good Luck

Hey Pavi,


This should work out for you....

Larry Please correct me if I m wrong, but I think in the solution you gave, even if the first column of file2 matches it will be placed in the result, but we need to compare the second column of file2. And please can you explain the -w option of grep please, this newb is a bit confused about it

Cheers,

Gaurav

Hello Gaurav.,

i tried with the cod eyou suggested.

########################################
## no output for this code ####
cat $FILE1 | while read LINE
do
col1=`echo $LINE|awk -F ":" '{print $1}'`
awk -F " " '{if ($2==$col1) print $0}' $FILE2 >> res.txt
done
cp res.txt result1.txt
rm res.txt

##########################################

it is creating 1byte file result.txt . it is not writing the output.

can you suggest ay alternate method.

thanks
pavi

Hi Pavi,

I looked carefully at the chain.txt and this may be hapeneing due to the difference in format of each line. Means the position of ':' is different for different records

Here is chain.txt

chain.txt contain;

ECK: ECK: 331
ECK: ECK: 336 (':' is just after the 1st coloumn)
FED :FED :427 ( As you can observe ':' is just before the 2nd column)
FIE :FIE: 212
FLN :FLN: 140
FLN :FLN :141
FMF: FMF: 183
FR1 :FR1: 303
FTT :FTT :423
GAT :GAT: 185
GEN :GEN: 396
GFY :GFY: 268
GIA :GIA: 228
GMD :GMD: 264
MIN: MIN: 158
MRO :MRO: 354
MY0 :MY0: 315
NCS :NCS: 390
OSC :ALBD: 377
OSC :ALBD :378
OSC: ALBD: 379
OSC ALBD 380 (No ':' in this record)
WLG :WLG :243
WLG: WLG: 244
WLG :WLG: 245
WLG :WLG :246
MAT: WLG :247

Are you sure that this file be like this only, otherwise if there is one uniform format for DS.txt and chain.txt, the solution will work.
I may be wrong, can some guru please throw some light on it.

If possible copy and paste some sample data from the files.

Bye,
Gaurav

Code:

[/tmp]$ cat pavan.ksh 
#! /bin/ksh
while read line
do
DL=${line%%:*}
sed -n -e "s_:.* *${DL} *.*:_&_p" chain.txt > result.txt
done < DS.txt
[/tmp]$ ./pavan.ksh 
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
[/tmp]$

Hello Gaurav.,

ALL the fields delimiter in chain.txt is a : ( colon delimited).
like ECK:ECK:331
ECK: ECK: 336
FED:FED:427
FIE:FIE: 212

when i was posting the question may be it was my type error.

chain.txt contain;

ECK: ECK: 336 (':' is just after the 1st coloumn) ( my typo error)
FED :FED :427 ( As you can observe ':' is just before the 2nd column)(type error)

tx
pavi


chain.txt contain;

ECK: ECK: 331
ECK: ECK: 336 (':' is just after the 1st coloumn)
FED :FED :427 ( As you can observe ':' is just before the 2nd column)
FIE :FIE: 212