UNIX for Dummies Questions & Answers

Hi All.,

i have a problem. I hope i can get some help on this issue here;
i have 2 txt files say file1 and file 2

file1 has;

WLMT:XXXXXXXX:cp
DOLR:YYYYYYY:ascii,unblock
WLG:TTTTTTT:dd:73:ascii,unblock
MAR:SSSSSS:dd:152:ascii,unblock
GGG:QQQQQQQQQQ:112:ascii,unblock
EIE:CCCCCCCC:cp
WLL:MMMMMMMMM:wlg_dd.ksh
WWW:IIIIIIIIII:dd:160:ascii,unblock

FILE2 has;

QQQQQQ:WLMT:GGGG
REWWE:WLG:NNNN
FSSG:PPP:VVSSG
UIUIUOLR:CXZMZ
VSDSS:MAR:FFYFBB
VFJHSJ:KKK:VXBVS
CNXBCXC:QQQ:CBVCZ

FILE1 and FILE2 are : delimited files.

i have to do a lookup between the FILE1 and FILE2 based on the 1st column of FILE1 and 2ND column of FILE2 and then write the output i.e matches only to a txt file say any name like result.txt

i.e from FILE1 the 1st column WLMT
DOLR
WLG
MAR
GGG
EIE
WLL
WWW

with the 2nd column of FILE2 ; WLMT
WLG
PPP
DOLR
MAR
KKK
QQQ

those that matches only., the script has to write the ouput to a txt file such as result.txt

can anyone please help in this issue

Thanks
pavi

Hi,
Right now now I have not unix facility in my system. But I can suggest you to use cut command. Using cut command get the required coloumn and store it in a variable. simillarly for 2nd file also. after that use for loop for comparision and redirect the output to your result file. Hope my suggestion does make any sense for you.

Thanks

Hi Pawan,
I hope the following script will work for you


This will give the common fields from column 1 of file1 and column2 of file2 in result.txt


Tell me if this helps you, comment out rm command and check if the f1 and f2 files are correct, in case the output is not what you require

If still there is some prblm write back

cheers,
Gaurav

Hello.,

thanks guys for your suggestions. let me try and then i will get back to you

tx
pavi

The input files of the comm command must be sorted.

Another solution with join command :

Code:

sort -o f1.txt -t: -k1,1 file1.txt
sort -o f2.txt -t: -k2,2 file2.txt
join -t: -11 -22 -o0 f1.txt f2.txt > result.txt
rm f1.txt f2.txt

Jean-Pierre.

Hi Guys.,

this is the code that i tried ;

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

awk -F ":" '{print $1}' $FILE1 > f1.txt
awk -F " " '{print $2}' $FILE2 > f2.txt
comm -12 f1.txt f2.txt > result.txt
#rm f1.txt f2.txt

f1.txt has

ALBD
BKS
FED
FLN
GIA
GIE
WLG
WND

f2.txt has

ALBD
ALBD
ALBD
BKS
FED
FED
FLN
FLN
ALBD
ALBD
ALBD
ALBD
WLG
WLG
WLG

the result.txt has only
WLG

can you please help where i am doing wrong

tx
pavi

I put your data in two files called a and b. "comm -12 a b" gave me:
ALBD
BKS
FED
FLN
WLG

The man page does say the data "should be" sorted. Your second file is not sorted. You try sorting it to see if that helps.