Maybe you could try grep -vf file2 file1, or some such.
What kind of "database" does this come from? A relational one? i.e. could you not do select X from Y where X not in (select X from Z)?
2 different databases on different servers. I only have access to one, the other is from another service. I just printed with awk what i needed so that both files are formated the same way.
I ll try that
As for sorting out files well i thought about it but some entries will be missing in the middle of x file and both lines will be out of sync again so diff wouldn't work. I think.
And yes Don, I also need lines that are present in file2 but not in file1.
How would you make that associative array using awk? this sound interesting.
I ll let you know how it goes, meh
---------- Post updated at 06:44 AM ---------- Previous update was at 01:19 AM ----------
Quote:
Originally Posted by Don Cragun
Do you only want to find lines that are in file1 that are not in file2, or do you also want to find lines that are in file2 that are not in file1?
---------- Post updated at 04:42 PM ---------- Previous update was at 04:00 PM ----------
If you can't perform a select as Scott suggested, there are at least a couple of fairly straight-forward ways of handling this. The easiest may well be the best:
Sort then diff seems to do the trick althought i have a weird output in the middle column. > and < I understand but what that a ' | 'mean?
Hi
I want to archive the following all the files and directory like listed below:
$ ls -a
. .. .bash_history .bash_logout .bash_profile .bashrc .emacs .mysql_history public_html .viminfo
What I tried is to use the following command
$ gtar cvzf allmyfiles.tar.gz *
... (1 Reply)
I have searched about 30 threads, a load of Google pages and cannot find what I am looking for. I have some of the parts but not the whole. I cannot seem to get the puzzle fit together.
I have three folders, two of which contain different versions of multiple files, dist/file1.php dist/file2.php... (4 Replies)
Hi there,
in near future I have to change my work surrounding from HP UNIX to Windows Vista (great to get rid of old hardware :), but bad to loose UNIX :( ). As I heavily use KSH scripts to do my job, I was wondering, if there is any HowTo available, supporting me in re-writing the scripts to... (4 Replies)
Hi, all:
I've got two folders, say, "folder1" and "folder2".
Under each, there are thousands of files.
It's quite obvious that there are some files missing in each. I just would like to find them. I believe this can be done by "diff" command.
However, if I change the above question a... (1 Reply)
I have four files, I need to compare these files together.
As such i know "sdiff and comm" commands but these commands compare 2 files together. If I use sdiff command then i have to compare each file with other which will increase the codes.
Please suggest if you know some commands whcih can... (6 Replies)
Morning all
I hope I have put this in the correct forum.
I have a requirement to monitor a directory on a server for files being sftp'ed in and then to sftp them of to another server. The issues I have though of are making sure the files have completely transferred onto the server before they... (6 Replies)
I have this code
awk 'NR==FNR{a=$1;next} a' file1 file2
which does what I need it to do, but for only two files. I want to make it so that I can have multiple files (for example 30) and the code will return only the items that are in every single one of those files and ignore the ones... (7 Replies)
HI All,
I am new to Unix shell scripts..
Could you please post the unix shell script for for the below request.,
There are two different tables(sample1, sample2) in different schemas(s_schema1, s_schema2).
Unix shell script to compare the columns of two different tables of two... (2 Replies)
Discussion started by: Rajkumar Gopal
2 Replies
LEARN ABOUT CENTOS
ldns-compare-zones
ldns-compare-zones(1) General Commands Manual ldns-compare-zones(1)NAME
ldns-compare-zones - read and compare two zonefiles and print differences
SYNOPSIS
ldns-compare-zones [-c] [-i] [-d] [-z] [-s] ZONEFILE1 ZONEFILE2
DESCRIPTION
ldns-compare-zones reads two DNS zone files and prints number of differences.
Output is formated to:
+NUM_INS -NUM_DEL ~NUM_CHG
The major comparison is based on the owner name. If an owner name is present in zonefile 1, but not in zonefile 2, the resource records
with this owner name are considered deleted, and counted as NUM_DEL. If an owner name is present in zonefile 2, but not in zonefile 1, the
resource records with this owner name are considered inserted, and counted as NUM_INS. If an owner name is present in both, but there is a
difference in the amount or content of the records, these are considered changed, and counted as NUM_CHG.
OPTIONS -c Print resource records whose owner names are in both zone files, but with different resource records. (a.k.a. changed)
-i Print resource records whose owner names are present only in ZONEFILE2 (a.k.a. inserted)
-d Print resource records whose owner names are present only in ZONEFILE1 (a.k.a. deleted)
-a Print all changes. Specifying this option is the same as specifying -c -i amd -d.
-z Suppress zone sorting; this option is not recommended; it can cause records to be incorrectly marked as changed, depending of the
nature of the changes.
-s Do not exclude the SOA record from the comparison. The SOA record may then show up as changed due to a new serial number. Off by
default since you may be interested to know if (other zone apex elements) have changed.
-h Show usage and exit
-v Show the version and exit
AUTHOR
Written by Ondej Sury <ondrej@sury.org> for CZ.NIC, z.s.p.o. (czech domain registry)
REPORTING BUGS
Report bugs to <ondrej@sury.org>.
COPYRIGHT
Copyright (C) 2005 CZ.NIC, z.s.p.o.. This is free software. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE.
17 Oct 2007 ldns-compare-zones(1)