Comparison of two files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Comparison of two files
# 1  
Old 07-26-2012
Comparison of two files

Hi all

I have two files which I have to compare that whetehr there is soemthing common or not

body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Liberation Sans"; font-size: x-small; }
Quote:
Gene Drug ADRB2 (PA39) hydrochlorothiazide (PA449899) WNK1 (PA33782) hydrochlorothiazide (PA449899) ERCC1 (PA155) Platinum compounds (PA164713176) ERCC1 (PA155) Platinum compounds (PA164713176) NEDD4L (PA31534) hydrochlorothiazide (PA449899) ADD1 (PA31) Antihypertensives (PA164712445) ADD1 (PA31) Thiazides, plain (PA164713347) CYP2C9 (PA126) simvastatin (PA45136




body, div, table, thead, tbody, tfoot, tr, th, td, p { font-family: "Liberation Sans"; font-size: x-small; }
Quote:
Gene Phenotype
ARFGEF2 CAD
DDEF2 CAD
PSCD3 CAD
PSCD4 CAD
CAMK1 CAD,HT,HT,HT,HT,HT,HT,HT,HT,HT,HT,HT,HT
HSP90AA1 CAD,CAD,CAD,T2D,T2D
KDR CAD,CD,CD
VEGF CAD,CAD,CAD,CAD,T2D,T2D,T2D
CTNNA3 CAD,HT,T2D
PTPRM CAD,T2D
RAC2 CAD,CAD,T1D,T1D
SMAD3 CAD,T2D,T2D,T2D,T2D,T2D,T2D,T2D
SORBS1 CAD,CAD,CAD
CD36 CAD
IRS1 CAD,CAD,CAD
IRS2 CAD,CAD,CAD,CAD
MTFMT CAD,CAD,CAD,T1D,T1D,T1D
SARS CAD
GNPDA2 CAD
NANS CAD











If column 1 in one file is matching wiht column 1 of second file then write column 2 of first file and column 2 of second file in front of it


Please let me know scripting regading this.

mani

Last edited by fpmurphy; 07-26-2012 at 08:17 AM..
# 2  
Old 07-26-2012
Do you want line-by-line matching?
# 3  
Old 07-26-2012
Request to check

hi

Thanks for reply.

I have a first ile like this

Quote:
Gene Drug
ADRB2 (PA39) hydrochlorothiazide (PA449899)
WNK1 (PA33782) hydrochlorothiazide (PA449899)
ERCC1 (PA155) Platinum compounds (PA164713176)
ERCC1 (PA155) Platinum compounds (PA164713176)
NEDD4L (PA31534) hydrochlorothiazide (PA449899)
ADD1 (PA31) Antihypertensives (PA164712445)
ADD1 (PA31) Thiazides, plain (PA164713347)
CYP2C9 (PA126) simvastatin (PA45136
so gene name in one file has to match with gene name in other file but PA39 is actually not included in gene name only letter in caps are inlcuded in genen name in second file.

So it shuld match only with gene name not PA entries

if its same then before that common name there shuld be entry of scondm column of scond file and first file with no PA entries if possible
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparison of files

I have the requirement I have two files cat fileA something anythg nothing everythg cat fileB everythg anythg Now i shld use fileB and compare every line at fileA and get the output as something nothing (3 Replies)
Discussion started by: Priya Amaresh
3 Replies

2. Shell Programming and Scripting

Complex comparison of 3 files

Hello to all in forum, May you experts could help me with this complex comparison please. I need to search the numbers in file1 within column3 of file2 and if found, compare column4 to NF of file2 with the lines in file3. If the column4 to NF in file2 match any of the lines in file3,... (5 Replies)
Discussion started by: Ophiuchus
5 Replies

3. Shell Programming and Scripting

Compare two files (Many to one comparison)

Hello, I am having output shown below names will change and can show different result and i want to compare with the checklist this file will not change it is standard settings. If there is some discrepancy than the complete line of output should be shown with name. I tried to use below... (10 Replies)
Discussion started by: rajjev_saini123
10 Replies

4. Shell Programming and Scripting

Comparison of multiple files

Need a write script in bournce shell. Compare all the file contents and need to generate a report. Example : Having 10 trace.log files like below trace1.log, trace2.log .... trace10.log Need to compare all the 10 files contents and provide the report as below, Assume trace... (1 Reply)
Discussion started by: sureshmani
1 Replies

5. Shell Programming and Scripting

Comparison of fields in Files

Hello, I have two files with tab delimited data. The file will contain details something like below: FILENAME.A.B.C. 3 5 VALID PROCESSED I would have a bench mark file. I would be getting new files of the same format. My requirement is to compare a particular field for a... (3 Replies)
Discussion started by: Praveenkulkarni
3 Replies

6. Shell Programming and Scripting

Comparison of two files (sh)

Hi, I have a problem with comparison of two files file1 20100101 20090101 20080101 20071001 20121229 file2 19990112 12 456 7 20011131 19 20100101 2 567 1 987 17890709 123 555 and, sh script needs to compare of these two files and give out to me result: 20100101 2 567 1 987 it... (5 Replies)
Discussion started by: shizik
5 Replies

7. UNIX for Dummies Questions & Answers

Comparison between binary files

Hello, I would like to know if we can compare binary(non text) files in unix eg. exes Thanks Saurabh (3 Replies)
Discussion started by: smehra_20
3 Replies

8. Shell Programming and Scripting

comparison of 2 files

Kindly help on follows. I have 2 files. One file contains only one column of mobile numbers. And total records in a file 12 million. Second file contains 2 columns mobile numbers and balance. and total records 30 million. I want to find out balance of each data in file 1 corresponding to file 2.... (2 Replies)
Discussion started by: kamal_418
2 Replies

9. UNIX for Dummies Questions & Answers

Comparison of 2 files in UNIX

Hi, There are two files in UNIX system with some lines are exactly the same, some lines are not. I want to compare these two files.The 2 files (both the files have data in Column format )should be compared row wise and any difference in data for a particular row should lead to storage of data of... (32 Replies)
Discussion started by: Dana Evans
32 Replies

10. Shell Programming and Scripting

Comparison of two files in awk

Hi, I have two files file1 and file2 delimited by semicolon, And I want to compare column 2 and column3 of file1 to column3 and column 4 in file2. file1 -------- abc;cef;155.67;143_34; def;fgh;146.55;123.3; frg;hff;134.67;; yyy;fgh;134.78;35_45; file 2 --------- abc;cef;155.09;;... (12 Replies)
Discussion started by: jerome Sukumar
12 Replies
Login or Register to Ask a Question