CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX 		Search Posts SEARCH
POSTS 		Who's Online WHO'S
ONLINE 		Log in LOG
IN

Home: Perl Programming Help: Beginner:
Compare Two Columns and fetch the data in front of it

 


manigrover
Novice

Sep 25, 2013, 1:23 PM

Post #1 of 3 (14700 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
Quote
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
Quote

Kindly help me regarding this.


2teez
Novice

Sep 26, 2013, 12:18 AM

Post #2 of 3 (14690 views)
Re: [manigrover] Compare Two Columns and fetch the data in front of it [In reply to] Can't Post
And how have you tried to solve this using Perl? Except you want your script written for you.


manigrover
Novice

Sep 26, 2013, 12:28 AM

Post #3 of 3 (14686 views)
Re: [2teez] Compare Two Columns and fetch the data in front of it [In reply to] Can't Post
Hi

Thanks for reply.

I was trying thus with unix code as I used this many times but now I have problem with my existing code as its not wrking witg this data. therefore. I m asking this.

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives