Compare 2 sorted files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Compare 2 sorted files
# 1  
Old 01-21-2008
Lightbulb Compare 2 sorted files

Hi all,

please give me the commands using which i can compare 2 sorted files and get the difference in third file, indiating where the difference is from either file1 or file2.

as:

File1 (Original file)

GARRY
JOHN
JULIE
SAM

---------------
File2

DEV
GARRY
JOHN
JOHNIEE
JULIE
RAMEE
SAM
SAMYEE
-------------------
OUTPUT in file3 should have :

DEV
JOHNIEE
RAMEE
SAMYEE


Using awk and diff/cmp commands.
# 2  
Old 01-21-2008
Try this:
Code:
comm -13 file1 file2

Code:
diff file1 file2 | awk '/^>/{print $2 }'

# 3  
Old 01-22-2008
Error

Quote:
Originally Posted by dennis.jacob
Try this:
Code:
comm -13 file1 file2

Code:
diff file1 file2 | awk '/^>/{print $2 }'


Could you please tell me why -13 is being used in comm command ?
# 4  
Old 01-22-2008
Try this one

grep -x -v -f F1 F2
# 5  
Old 01-22-2008
MySQL

Quote:
Originally Posted by ranjithpr
grep -x -v -f F1 F2
Hey,

thanks man, hope this'll work fine.


Smilie
Varun.
# 6  
Old 01-23-2008
Quote:
Originally Posted by varungupta
Could you please tell me why -13 is being used in comm command ?


-1 suppress lines unique to left file

-2 suppress lines unique to right file

-3 suppress lines that appear in both files
# 7  
Old 01-25-2008
Lightbulb

Quote:
Originally Posted by ranjithpr
grep -x -v -f F1 F2
Hey,

I have attached 2 files in this mail, please find those, in which i am doing comparisions.
Contents of EAIDVBR1.txt are standard and Contents of EAIDQBR1.txt are mixed.
I want list of all strings from EAIDQBR1.txt that are not there in EAIDVBR1.

Please have a look and let me know. As i have tries "grep -x -v -f F1 F2" command on these files and its not working effectively.

Let me know asap.
Thanks
VarunSmilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to create a summary file of all files in a directory sorted in reverse alphabetical order.?

I have an interactive script which works terrific at processing a folder of unsorted files into new directories. I am wondering how I could modify my script so that( upon execution) it provides an additional labelled summary file on my desktop that lists all of the files in each directory that... (4 Replies)
Discussion started by: Braveheart
4 Replies

2. Shell Programming and Scripting

Is there a way to join 2 text files sorted by

Can anyone please help me i have 2 text files setup like the one below. Textfile1: randomemail1:randompassword1 randomemail2:randompassword2 randomemail3:randompassword3 randomemail4:randompassword4 randomemail5:randompassword5 Textfile2: randompassword1:randomphrase1... (8 Replies)
Discussion started by: nufc
8 Replies

3. Shell Programming and Scripting

Paste multiple files, but only the sorted head -50

Hello, I want to merge multiple files (under hundreds folders) side by side. File name are the same but folder are different. like folder1/same_name.txt folder2/same_name.txt folder3/same_name.txt ......Normally it can be done as paste /different_path*/same_name.txt > merged_file.txtbut... (2 Replies)
Discussion started by: yifangt
2 Replies

4. Shell Programming and Scripting

sort the files based on timestamp and execute sorted files in order

Hi I have a requirement like below I need to sort the files based on the timestamp in the file name and run them in sorted order and then archive all the files which are one day old to temp directory My files looks like this PGABOLTXML1D_201108121235.xml... (1 Reply)
Discussion started by: saidutta123
1 Replies

5. Shell Programming and Scripting

combine multiple files by column into one files already sorted!

I have multiple files; each file contains a certain data in a column view simply i want to combine all those files into one file in columns example file1: a b c d file 2: 1 2 3 4 file 3: G (4 Replies)
Discussion started by: ahmedamro
4 Replies

6. UNIX for Dummies Questions & Answers

write a program in c in unix that display the files(includ sub-direc and files within) in a sorted

the sorting is based on name of file, file size modification time stamps o f file it should dislay the output in the following format "." and ".." enteries should be ignored please give some idea how to do it (1 Reply)
Discussion started by: pappu kumar jha
1 Replies

7. Programming

merging two files with sorted integers in c

Hi, I want to merge two files with sorted integers. I want to merge two files to a single file such that there are no duplicates and the merged file should contain the integers in the sorted order. Just some idea or pointer to an implementation will help me a lot. Thanks & Regards,... (4 Replies)
Discussion started by: brett01
4 Replies

8. Shell Programming and Scripting

concatenate files sorted by date

I am a beginner in script writing, i tried to do the following I have a set of files sorted by date in the format YYMMDD.s and .x and .r I need to concatenate a header file to these sets of files so I used the following code echo "enter Swath number" read s echo "please enter first date and... (2 Replies)
Discussion started by: docaia
2 Replies

9. UNIX for Dummies Questions & Answers

grep content of files sorted by time stamp

egrep Date: *.html > out.htm I would like to grep the match as sorted by time stamp of the html files. how do I do that? (1 Reply)
Discussion started by: zer0
1 Replies

10. Shell Programming and Scripting

executing code on files in the sorted order -help!

Say i have 2 files in the giving format: file1 1 2 3 4 1 2 3 4 1 2 3 4 file2 1 2 3 4 1 2 3 4 1 2 3 4 I have a PERL code (loaned by one of u -i forgot who - thanks!) that extracts the 2nd column from each file and append horizontally to a new file: perl -ane 'push @{$L->}, $F; close... (1 Reply)
Discussion started by: epi8
1 Replies
Login or Register to Ask a Question