Compare 2 flat files

ganesh123 · #1 (**permalink**) 03-16-2007

Hi Gurus,

I searched the forum but didnt get much info.
I want to compare 2 files.

1)Newfile comes today with
2)Old file of previous day.

The files are same ,just the new files might have new records sometimes.

So I want to capture these new records in another file.

Can anyone help me in this ??

Thanks

thestevew · #2 (**permalink**) 03-16-2007

If all you just want is a file containing the differences between your old and new files then try:

Code:

diff old_file new_file > diff_file

lines only in new_file will be preceded by >

ganesh123 · #3 (**permalink**) 03-16-2007

thanks for reply but I guess using diff will also give the records which are present in old file and not in new file.

I just want to capture the records not present in old file and present in new file.

strobotta · #4 (**permalink**) 03-16-2007

The following should work:

Code:

diff old_file new_file | grep ">" | cut -b 3- > new_records.txt

grep entries that are in the newer file only, and cut the first two leading chars that diff outputs.

Records that are in the old file only will not be in the new one.

Deal_NoDeal · #5 (**permalink**) 03-16-2007

Quote:

Originally Posted by ganesh123

Hi Gurus,

I searched the forum but didnt get much info.
I want to compare 2 files.

1)Newfile comes today with
2)Old file of previous day.

The files are same ,just the new files might have new records sometimes.

So I want to capture these new records in another file.

Can anyone help me in this ??

Thanks

If you are on solaris, you can use:

/usr/xpg4/bin/grep -v -f oldfile newfile > diff_file

ganesh123 · #6 (**permalink**) 03-16-2007

Thankyou everybody for your precious time.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Help with Flat Files Please!! BASH (New User)	cyberjax21	Shell Programming and Scripting	0	02-27-2006 09:19 PM
How to compare two flat files and get changed data	jtshashidhar	Shell Programming and Scripting	3	01-29-2006 10:26 PM
Column names in flat files	srivsn	Shell Programming and Scripting	1	12-27-2005 06:47 AM
How to compare data in two flat files and update them?	rajus19	Shell Programming and Scripting	3	11-08-2005 11:13 AM
Flat Files	thumsup9	Shell Programming and Scripting	2	02-02-2005 03:21 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by