Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Difference of more than 2 files....

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Difference of more than 2 files....
# 1  
Old 04-21-2009
Difference of more than 2 files....
Hi All,
I need your help to find out the difference between 3 files.
Quote:
FILE1:
XXX,001,100
XXX,890,120
XXX,672,130
YYY,123,140
YYY,897,222
ZZZ,903,789

FILE2:
XXX,001,100
XXX,890,120
XXX,672,130
YYY,123,140
YYY,897,222
YYY,900,100
ZZZ,903,789

FILE3:
XXX,001,100
XXX,890,120
XXX,672,130
YYY,123,140
YYY,897,222
ZZZ,903,789
ZZZ,904,908
How can i get the output which says that FILE2 contains additional (YYY,900,100) compare to FILE1 and FILE3 contains addition record (ZZZ,904,908) compare to FILE1?
I have tried using diff3 command, but was not able to get help. Appreciate if someone help me on this.
# 2  
Old 06-01-2009
diff3 would be the command to use for this. What are the error messages you are getting and what help do you exactly need?
# 3  
Old 06-01-2009
Code:
for i in `comm -13 file1 file2`;do
echo "File 2 contains additional record: $i"
done

for i in `comm -13 file1 file3`;do
echo "File 3 contains additional record: $i"
done

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Comparing two files and list the difference with common first line content of both files

I have two file as given below which shows the ACL permissions of each file. I need to compare the source file with target file and list down the difference as specified below in required output. Can someone help me on this ? Source File ************* # file: /local/test_1 # owner: own #... (4 Replies)
Discussion started by: sarathy_a35
4 Replies

2. Shell Programming and Scripting

How to get the difference with 4 files?

HI Team, Could you please help me here. I need to compare 4 files a) 1 2 3 4 b) 1 5 3 4 c) 1 2 5 (1 Reply)
Discussion started by: madhuchilipi
1 Replies

3. UNIX for Dummies Questions & Answers

Difference in two files

Hi all, I have problem in finding the difference. suppose i have two file file1 file2 1xyz 1xyz 1asd 1xyz 1asd 1abc 2adf 1asd 3asd 2abd 4abc 2adf 3asf I need to... (7 Replies)
Discussion started by: XXLMMN
7 Replies

4. UNIX for Advanced & Expert Users

Difference between two files?

I need the get the difference between 2 files and the result, I need to output it to an other file file1 1 1 2 file2 1 1 2 3 Result....File3=3 used diff file1 file2 > file3 ( not working as expected)..Exact requirement..I have 2 flatfiles to compare and load only the difference in a... (0 Replies)
Discussion started by: win4luv
0 Replies

5. Shell Programming and Scripting

difference between two files

i have two files A and B and i want the difference to be printed in file C as in example below File A 10E32E7BCC5881DDB6||002878|1|1| 10E32E7BCC5881DDB7||002878|1|1| 10E32E7BCC5881DDB8||002878|1|1| 10E32E7BCC5881DDB9||002878|1|1| File B 10E32E7BCC5881DDB1||002878|1|1|... (4 Replies)
Discussion started by: tomjones
4 Replies

6. Shell Programming and Scripting

difference in files.

Hi All, **************************************************************** File1: CREATE TABLE "TESTIHUB"."CINEMA" ( "NAME" VARCHAR2(20), "ACTOR" VARCHAR2(20), "YEAR" NUMBER ); / CREATE TABLE "TESTIHUB"."PANT" ( "CNAME" VARCHAR2(20), "AMOUNT" NUMBER, ... (1 Reply)
Discussion started by: naree
1 Replies

7. Shell Programming and Scripting

Difference between two files

HI Folks, sorry if it is a naive question. i have two files . "file1.txt" & "file2.txt" contents in files: file1.txt file2.txt -------- --------- 1 ... (2 Replies)
Discussion started by: babusek
2 Replies

8. Shell Programming and Scripting

Difference between files

I have two files like follows: - File 1: - A 20 B 15 D 10 C 6 File 2: - B 21 A 20 C 11 D 10 Now I want file like this: - It should pick up 'A' from File 1 and pick up 'A' from File 2 and should get difference of the numbers in 2nd column and display result as follows ... (2 Replies)
Discussion started by: balu_puttaganti
2 Replies

9. Shell Programming and Scripting

Difference between .pm and .pl files

I know the basic difference between .pm and .pl files. But wat puzzles me is when to go for creating a module and when to create .pl files.Based on wat criteria we sholud decide to make a function whcih implements a common functionality as module or a .pl file ?? (3 Replies)
Discussion started by: Anuj8584
3 Replies

10. Shell Programming and Scripting

difference b/w files

i have 2 files file 1---------> hello file 2---------> hello world is there any command that we find the diff b/w two files and gives the ans as what is not matched with file 2. diff file 1 file 2 here the desired o/p should be: world as "world" is not found in file 1. (2 Replies)
Discussion started by: ali560045
2 Replies
Login or Register to Ask a Question