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
UIUIU
OLR: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