Shell Programming and Scripting

Hi, I have 2 files which represent data in a Sybase table and I need to run a diff on them, and based on the first column (which is the primary key) in each file, create 3 files, one for inserts, one for deletes and one for updates

Example:
old.txt contains

Code:

server1,a,b,c
server2,d,e,f
server4,j,k,l
server5,m,n,o

new.txt contains

Code:

server2,a,b,c
server3,g,h,i

So the output files would be:
delete.txt

Code:

server1,a,b,c
server4,j,k,l
server5,m,n,o

insert.txt

Code:

server3,g,h,i

update.txt

Code:

server2,a,b,c

So far I have something which puts the output into a single file with a delta code of I or D, but I can't figure out how to get the U part.


Any help would be appreciated!

Thanks

What is the input file?
What are the rules for the various files?
Not clear from your description.

The input files are old.txt and new.txt - they contain text that represents data in a Sybase table with the first columns being the primary key. Based on that, I want to run a diff / awk / sed script which will compare the rows in the two files and produce a file with the inserts (rows that exist in new.txt but not old.txt), deletes (rows that exist in old.txt but not new.txt) and updates (rows that exist in both but have different data besides the primary key)

Hope that helps. Thanks

Code:

comm
diff

commands?

I don't have them yet, that's why I'm posting here. I want to know if anyone has any existing code which will do this, perhaps with a combination of diff, awk, sed, etc.