Re^2: comparing data btwn 2 files

^^my data in the .txt file is something like this:


Bacteroides thetaiotaomicron    C00267    5.3.1.9      C00668
Bacteroides thetaiotaomicron    C00221    5.3.1.9      C01172
Bacteroides thetaiotaomicron    C00074    5.3.1.9      C00022
Bacteroides thetaiotaomicron    C00221    5.3.1.1      C00267
 Parabacteroides Distasonis    C02876     2.7.2.1      C00163
[download]


Homosapiens    C00267    2.7.1.2        C00668
Homosapiens    C00267    5.1.3.3        C00221
Homosapiens    C00221    5.1.3.3        C00267
Homosapiens    C00221    2.7.1.2        C01172
Homosapiens    C00221    2.7.1.1        C01172
Homosapiens    C00668    5.3.1.9        C01172
Homosapiens    C01172    5.3.1.9        C00668
Homosapiens    C00668    5.3.1.9        C05345
Homosapiens    C05345    5.3.1.9        C00668
[download]

i want to compare the second, third and fourth columns in the 2 files..and find the matches.

Comment on Re^2: comparing data btwn 2 files Select or Download Code

Replies are listed 'Best First'.
Re^3: comparing data btwn 2 files by tospo (Hermit) on May 12, 2011 at 08:20 UTC
ok, if yuo only need the matches and don't need to know which elements are only in the bacterium or only in human then your approach will be sufficient.	[reply]