Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Find common entries
Top Forums Shell Programming and Scripting Find common entries Post 302725255 by manigrover on Friday 2nd of November 2012 02:43:51 AM
Old 11-02-2012
Hi


Thanks a lot. I checked this. but I don't knw but because of some issue it's not wrking on my another dataset

I which first file is like this

Code:
Lepirudin 
Cetuximab 
 Tyloxapol 
Trospium 
Dornase Alfa 
Denileukin diftitox 
Etanercept 
Bivalirudin 
Leuprolide 
 M-Cresol 
Adenosine Monotungstate 
Peginterferon alfa-2a 
Alteplase 
Sermorelin 
Interferon alfa-n1 
Darbepoetin alfa 
Urokinase 
Goserelin 
Reteplase 
Epoetin alfa 
Salmon Calcitonin 
Interferon alfa-n3

And, the second file

Code:
FHIT     Adenosine Monotungstate    Not Available,T2D    Ado-P-Ch2-P-Ps-Ado    Not Available,                                                                                                                                                                                                                                                                                                 
CHRM1     Trospium    Sanctura T2D    Oxyphenonium    Antrenyl T2D                                                                                                                                                                                                                                                                                                 
PDE3B     5r-6-4-2-3-Iodobenzyl-3-Oxocyclohex-1-En-1-YlAminoPhenyl-5-Methyl-4,5-Dihydropyridazin-32h-One    Not Available,T1D    Hg9a-9, Nonanoyl-N-Hydroxyethylglucamide    Not Available,                                                                                                                                                                                                                                                                                                 
HSP90AA1     9-Butyl-8-2,5-Dimethoxy-Benzyl-9h-Purin-6-Ylamine    Not Available,T2D    8-2-Chloro-3,4,5-Trimethoxy-Benzyl-2-Fluoro-9-Pent-4-Ylnyl-9h-Purin-6-Ylamine    Not Available,T2D                                                                                                                                                                                                                                                                                                 
ESR1     Chlorotrianisene    Anisene,BD    Conjugated Estrogens    Conestoral,BD                                                                                                                                                                                                                                                                                                 
INS     M-Cresol    Not Available,                                                                                                                                                                                                                                                                                                         
FAH     Acetoacetic Acid    Not Available,BD    4-Hydroxy-Methyl-Phosphinoyl-3-Oxo-Butanoic Acid    Not Available,                                                                                                                                                                                                                                                                                                 
LPL     Tyloxapol    Alevaire,                                                                                                                                                                                                                                                                                                         
ADAM17     3S-1-4-BUT-2-YN-1-YLOXYPHENYLSULFONYLPYRROLIDINE-3-THIOL    Not Available T2D    3-4-but-2-yn-1-yloxyphenylsulfonylpropane-1-thiol    Not Available T2D

And, expected output is to write "approved" if the word of firs file matches in even number of columns I think there is problem of tab separation therefore its adding

Code:
FHIT     Adenosine Monotungstate (approved)    Not Available,T2D     Ado-P-Ch2-P-Ps-Ado    Not Available,                                                                                                                                                                                                                                                                                                     
CHRM1     Trospium (approved)    Sanctura T2D    Oxyphenonium    Antrenyl T2D                                                                                                                                                                                                                                                                                                     
PDE3B      5r-6-4-2-3-Iodobenzyl-3-Oxocyclohex-1-En-1-YlAminoPhenyl-5-Methyl-4,5-Dihydropyridazin-32h-One     Not Available,T1D    Hg9a-9, Nonanoyl-N-Hydroxyethylglucamide    Not  Available,                                                                                                                                                                                                                                                                                                     
HSP90AA1     9-Butyl-8-2,5-Dimethoxy-Benzyl-9h-Purin-6-Ylamine    Not  Available,T2D     8-2-Chloro-3,4,5-Trimethoxy-Benzyl-2-Fluoro-9-Pent-4-Ylnyl-9h-Purin-6-Ylamine     Not Available,T2D                                                                                                                                                                                                                                                                                                     
ESR1     Chlorotrianisene    Anisene,BD    Conjugated Estrogens     Conestoral,BD                                                                                                                                                                                                                                                                                                     
INS     M-Cresol (approved)   Not Available,                                                                                                                                                                                                                                                                                                             
FAH     Acetoacetic Acid    Not Available,BD     4-Hydroxy-Methyl-Phosphinoyl-3-Oxo-Butanoic Acid    Not Available,                                                                                                                                                                                                                                                                                                     
LPL     Tyloxapol (approved)    Alevaire

But received out put is somethign like this. I feel there is problem to tab separation therefore only soem entries show approved and that just after first word not the whole word

Code:
FHIT Adenosine (approved) Monotungstate Not Available,T2D Ado-P-Ch2-P-Ps-Ado Not Available,  
CHRM1     Trospium    Sanctura T2D    Oxyphenonium    Antrenyl T2D                                                                                                                                                                                                                                                                                                 
PDE3B     5r-6-4-2-3-Iodobenzyl-3-Oxocyclohex-1-En-1-YlAminoPhenyl-5-Methyl-4,5-Dihydropyridazin-32h-One    Not Available,T1D    Hg9a-9, Nonanoyl-N-Hydroxyethylglucamide    Not Available,                                                                                                                                                                                                                                                                                                 
HSP90AA1     9-Butyl-8-2,5-Dimethoxy-Benzyl-9h-Purin-6-Ylamine    Not Available,T2D    8-2-Chloro-3,4,5-Trimethoxy-Benzyl-2-Fluoro-9-Pent-4-Ylnyl-9h-Purin-6-Ylamine    Not Available,T2D                                                                                                                                                                                                                                                                                                 
ESR1 Chlorotrianisene Anisene,BD Conjugated (approved) Estrogens Conestoral,BD  
INS     M-Cresol    Not Available,                                                                                                                                                                                                                                                                                                         
FAH     Acetoacetic Acid    Not Available,BD    4-Hydroxy-Methyl-Phosphinoyl-3-Oxo-Butanoic Acid    Not Available,                                                                                                                                                                                                                                                                                                 
LPL     Tyloxapol    Alevaire,                                                                                                                                                                                                                                                                                                         
ADAM17     3S-1-4-BUT-2-YN-1-YLOXYPHENYLSULFONYLPYRROLIDINE-3-THIOL    Not Available T2D    3-4-but-2-yn-1-yloxyphenylsulfonylpropane-1-thiol    Not Available

 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To find all common lines from 'n' no. of files

Hi, I have one situation. I have some 6-7 no. of files in one directory & I have to extract all the lines which exist in all these files. means I need to extract all common lines from all these files & put them in a separate file. Please help. I know it could be done with the help of... (11 Replies)
Discussion started by: The Observer
11 Replies

2. Shell Programming and Scripting

find common data

Hey guys, I have two files. file1 and file2. file1: a,1 b,2 c,343 d,343 e,4343 f,4544 file 2: a, d, e, Now i need to find the common data between these files from file1. i.e a,1 (8 Replies)
Discussion started by: jaituteja
8 Replies

3. Shell Programming and Scripting

Request to check:find out common entries

I have to compare 2 files which means 2 files with common entries in same column and separate those common entries in a diferent file as well right before those entries common so that I can separat common and Uncommon entries in rows in 2 different files. Is it possible For eg. one file ... (3 Replies)
Discussion started by: manigrover
3 Replies

4. Shell Programming and Scripting

Find common entries in 2 list and write data before it

Hi all, I have 2 files: second file I want if entries in one file will match in other file. It shuld wite approve before it so output shuld be (1 Reply)
Discussion started by: manigrover
1 Replies

5. Shell Programming and Scripting

find common entries and match the number with long sequence and cut that sequence in output

Hi all, I have a file like this ID 3BP5L_HUMAN Reviewed; 393 AA. AC Q7L8J4; Q96FI5; Q9BQH8; Q9C0E3; DT 05-FEB-2008, integrated into UniProtKB/Swiss-Prot. DT 05-JUL-2004, sequence version 1. DT 05-SEP-2012, entry version 71. FT COILED 59 140 ... (1 Reply)
Discussion started by: manigrover
1 Replies

6. Shell Programming and Scripting

Find common numbers and print yes or no

Hi I have 2 files with following data First file, sp|Q676U5|A16L1_HUMAN, Autophagy-related protein 16-1 OS=Homo sapiens GN=ATG16L1 PE=1 SV=2, Maximum coiled-coil residue probability: 0.657 in position 163. Maximum dimeric residue probability: 0.288 in position 163. ... (1 Reply)
Discussion started by: manigrover
1 Replies

7. Shell Programming and Scripting

Find the common values

Hi, I have two files with the below values. file1 305231921 1.0 ben/Ben_Determination_Appeals 1348791394 2.0 ben/Ben_Determination_Appeals] 1305231921 1.0 ben/Cancel_Refund_Payment_JLRS 1348791394 2.0 ben/Cancel_Refund_Payment_JLRS 1305231921 ... (2 Replies)
Discussion started by: Vikram_Tanwar12
2 Replies

8. Shell Programming and Scripting

Find common words

Hi, I have 10 files which needs to be print common words from those all files. Is there any command to find out. (2 Replies)
Discussion started by: munna_dude
2 Replies

9. Shell Programming and Scripting

Find common files between two directories

I have two directories Dir 1 /home/sid/release1 Dir 2 /home/sid/release2 I want to find the common files between the two directories Dir 1 files /home/sid/release1>ls -lrt total 16 -rw-r--r-- 1 sid cool 0 Jun 19 12:53 File123 -rw-r--r-- 1 sid cool 0 Jun 19 12:53... (5 Replies)
Discussion started by: sidnow
5 Replies
All times are GMT -4. The time now is 07:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy