Hi all
I have two files which I have to compare that whetehr there is soemthing common or not
body, div, table, thead, tbody, tfoot, tr, th, td, p \{ font-family: "Liberation Sans"; font-size: x-small; \}
Gene Drug ADRB2 (PA39) hydrochlorothiazide (PA449899) WNK1 (PA33782) hydrochlorothiazide (PA449899) ERCC1 (PA155) Platinum compounds (PA164713176) ERCC1 (PA155) Platinum compounds (PA164713176) NEDD4L (PA31534) hydrochlorothiazide (PA449899) ADD1 (PA31) Antihypertensives (PA164712445) ADD1 (PA31) Thiazides, plain (PA164713347) CYP2C9 (PA126) simvastatin (PA45136
body, div, table, thead, tbody, tfoot, tr, th, td, p \{ font-family: "Liberation Sans"; font-size: x-small; \}
Gene Phenotype
ARFGEF2 CAD
DDEF2 CAD
PSCD3 CAD
PSCD4 CAD
CAMK1 CAD,HT,HT,HT,HT,HT,HT,HT,HT,HT,HT,HT,HT
HSP90AA1 CAD,CAD,CAD,T2D,T2D
KDR CAD,CD,CD
VEGF CAD,CAD,CAD,CAD,T2D,T2D,T2D
CTNNA3 CAD,HT,T2D
PTPRM CAD,T2D
RAC2 CAD,CAD,T1D,T1D
SMAD3 CAD,T2D,T2D,T2D,T2D,T2D,T2D,T2D
SORBS1 CAD,CAD,CAD
CD36 CAD
IRS1 CAD,CAD,CAD
IRS2 CAD,CAD,CAD,CAD
MTFMT CAD,CAD,CAD,T1D,T1D,T1D
SARS CAD
GNPDA2 CAD
NANS CAD
If column 1 in one file is matching wiht column 1 of second file then write column 2 of first file and column 2 of second file in front of it
Please let me know scripting regading this.
mani
clx
July 26, 2012, 6:41am
2
Do you want line-by-line matching?
hi
Thanks for reply.
I have a first ile like this
Gene Drug
ADRB2 (PA39) hydrochlorothiazide (PA449899)
WNK1 (PA33782) hydrochlorothiazide (PA449899)
ERCC1 (PA155) Platinum compounds (PA164713176)
ERCC1 (PA155) Platinum compounds (PA164713176)
NEDD4L (PA31534) hydrochlorothiazide (PA449899)
ADD1 (PA31) Antihypertensives (PA164712445)
ADD1 (PA31) Thiazides, plain (PA164713347)
CYP2C9 (PA126) simvastatin (PA45136
so gene name in one file has to match with gene name in other file but PA39 is actually not included in gene name only letter in caps are inlcuded in genen name in second file.
So it shuld match only with gene name not PA entries
if its same then before that common name there shuld be entry of scondm column of scond file and first file with no PA entries if possible