
manigrover
Novice
Sep 25, 2013, 1:23 PM
Post #1 of 3
(14338 views)
|
Compare Two Columns and fetch the data in front of it
|
Can't Post
|
|
Dear all I have two files to compare One file contains Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Muscarinic acetylcholine receptor M1 Second file contains Muscarinic acetylcholine receptor _Name _Muscarinic acetylcholine receptor Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M2 _UniProt ID _P08172 Muscarinic acetylcholine receptor M3 _UniProt ID _P20309 Muscarinic acetylcholine receptor M4 _UniProt ID _P08173 Muscarinic acetylcholine receptor M5 _UniProt ID _P08912 Vascular endothelial growth factor receptor 1 _UniProt ID _P17948 Vascular endothelial growth factor receptor 2 _UniProt ID _P35968 I have to check if there is completely common entries in the first column of both files than it should fetch the data in fornt of it so for above example expected output is Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229 Muscarinic acetylcholine receptor M1 _UniProt ID _P11229
Kindly help me regarding this.
|