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 (671 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 (661 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 (657 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