comparing two files and find mismatch


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting comparing two files and find mismatch
# 8  
Old 02-15-2009
Code:
nawk 'BEGIN{FS="|"}
{
if (NR==FNR)
	_[$1]=$0
else
{
	if (_[$1]!=$0){
		print _[$1]
		print $0
		print "---------"
	}
}
}' f1 f2

# 9  
Old 02-18-2009
thanx sir
that is working fine
and i got my reruired data

dear i thing more now suppose bOth the files filds are heading with

A,B,C,D and i want to compare both the files on the bases of 1st field and print only 1st filed and that mismatch field

# cat file1
A |B |C|D |E|F|g|H|I|J
00354|1|0|1|1|0|0|0|1|2
52424|1|0|1|1|0|0|0|1|2
43236|1|0|1|1|0|0|0|1|2
41404|1|0|1|1|0|0|0|1|2
79968|1|0|1|1|0|0|0|1|2
# cat file2
A |B |C|D |E|F|g|H|I|J
00354|1|0|1|1|0|0|0|1|2
52424|1|0|1|1|0|0|0|0|2
43236|1|0|1|1|0|0|0|0|2
41404|1|0|1|1|0|0|0|1|2
79968|1|0|1|1|0|0|0|1|2
NOTE : files are too large and diff may be in any filed.
o/p should be
A | I
file1:52424|1|
file2:52424|0|
-----------------
file1:43236|1|
file2:43236|0|
# 10  
Old 02-18-2009
Quote:
Originally Posted by dodasajan
thanx sir
that is working fine
and i got my reruired data
Which one of the above Sirs (or maybe ladies for that matter) are you referring to?
Quote:
Originally Posted by dodasajan
dear i thing more now suppose bOth the files filds are heading with

A,B,C,D and i want to compare both the files on the bases of 1st field and print only 1st filed and that mismatch field

# cat file1
A |B |C|D |E|F|g|H|I|J
00354|1|0|1|1|0|0|0|1|2
52424|1|0|1|1|0|0|0|1|2
43236|1|0|1|1|0|0|0|1|2
41404|1|0|1|1|0|0|0|1|2
79968|1|0|1|1|0|0|0|1|2
# cat file2
A |B |C|D |E|F|g|H|I|J
00354|1|0|1|1|0|0|0|1|2
52424|1|0|1|1|0|0|0|0|2
43236|1|0|1|1|0|0|0|0|2
41404|1|0|1|1|0|0|0|1|2
79968|1|0|1|1|0|0|0|1|2
NOTE : files are too large and diff may be in any filed.
o/p should be
A | I
file1:52424|1|
file2:52424|0|
-----------------
file1:43236|1|
file2:43236|0|
ok, this a new requirement.
Having the first task behind you/us and understanding it completely, how far have you gotten so far implementing a new requirement reusing the gained knowledge?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Find Syllable count mismatch

Hello, I have written a syllable splitter for Pseudo English and Indic. I have a large database with the following structure Syllables in Pseudo English delimited by |=Syllables in Devanagari delimited by | The tool produces syllables in both scripts. An example is given below: ... (2 Replies)
Discussion started by: gimley
2 Replies

2. AIX

Compare two files and show the mismatch columns

I need to compare two files and find the mismatch columns in it for csv and fixed width file. Eg: file1 c1,c2,c3,c4<----columnname 1,a,4,d 2,b,5,e 3,c,6,f file2 c1,c2,c3,c4<----columnname 3,x,7,f 2,y,8,e 1,z,9,d output c2,c3<---- mismatch columname a,4 x,7 b,5 or y,8 Ok with... (3 Replies)
Discussion started by: sabzR
3 Replies

3. Shell Programming and Scripting

Need help in comparing two files in UNIX with a mismatch

Hi Everyone, I am comparing results of two environments using unix files. I am writing two different csv file using spool and merging both the files using paste command paste -d, file1.csv file2.csv > prod_uat_result.csv and then finding the difference and attaching the same in a mail... (8 Replies)
Discussion started by: karthik adiga
8 Replies

4. UNIX for Advanced & Expert Users

How to find duplicates contents in a files by comparing other files?

Hi Guys , we have one directory ...in that directory all files will be set on each day.. files must have header ,contents ,footer.. i wants to compare the header,contents,footer ..if its same means display an error message as 'files contents same' (7 Replies)
Discussion started by: Venkatesh1
7 Replies

5. UNIX for Dummies Questions & Answers

Files count mismatch when used with Tar with find

Hi I have used the below steps and found some discrepancies step 1 : find ./ -type f -mtime +7 -name "*.00*" | wc -l = 13519 ( total files ) ( the size of this files is appx : 10GB ) step 2: find ./ -type f -mtime +7 -name "*.00*" | xargs tar zcvf Archieve_7.tar.gz step... (7 Replies)
Discussion started by: rakeshkumar
7 Replies

6. Shell Programming and Scripting

Script to find files and delete it by comparing

I have a directory where lot of "gzip" files are dropped in every 5 minutes. There is an application which will process these gzip and move it to another directory but will leave a gzip.out file with lot of output data. I need to remove all the outfiles except for the one which is being... (1 Reply)
Discussion started by: gubbu
1 Replies

7. Shell Programming and Scripting

Compare two files and mismatch report

Hi I have two files f1 and f2 and comma separated file. I need to comapre two files by field by field and not by whole line. If they match then skip the line from both the files. If they don't match write the mismatch record from f1 to f3. Assume both the files are sorted on first field. ... (5 Replies)
Discussion started by: dgmm
5 Replies

8. Shell Programming and Scripting

To find String mismatch

Hi, I have a doubt when searching files for the existence of a particular key. I have a property file has data with key and value pair like below and i call it as property file.ini here are the contents in File: popertyfile.ini location.property=2 agent.method=begin newkey=23 ... (2 Replies)
Discussion started by: raghu.amilineni
2 Replies

9. Shell Programming and Scripting

Find duplicate value comparing 2 files and create an output

I need a perl script which will create an output file after comparing two diff file in a directory path: /export/home/abc/file1 /export/home/abc/file2 File Format: <IP>TAB<DeviceName><TAB>DESCRIPTIONS file1: 10.1.2.1.3<tab>abc123def<tab>xyz.mm1.ppp.... (2 Replies)
Discussion started by: ricky007
2 Replies

10. UNIX for Dummies Questions & Answers

Help comparing 2 files to find deleted records

Hi, I need to compare todays file to yesterdays file to find deletes. I cannot use comm -23 file.old file.new. Because each record may have a small change in it but is not really a delete. I have two delimited files. the first field in each file is static. All other fields may change. I... (2 Replies)
Discussion started by: eja
2 Replies
Login or Register to Ask a Question