11-08-2005
Could you please suggest me how to replace two fields in a flat file which contains more than 40 fields.
If I use sed by searching for the strings there may be a chance that the same string occurs in other fields also.
If I use awk I explicitly metion the rest of the 38 fields.
Please suggest me how to deal with this.
Thanks in advance
Raju
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
does anyone know of a way to compare files update time (not only days - also hours and minutes) (command? scripts? perl scripts?)
Dori (8 Replies)
Discussion started by: dorilevy
8 Replies
2. Shell Programming and Scripting
I would like to compare a data file (before and after a process has run) to identify if there are any differences. Can anyone help !! (1 Reply)
Discussion started by: ithomp
1 Replies
3. Shell Programming and Scripting
Hi,
I need to compare two flat files (yesterday & today's data) and get only the changed data from flat files. In flat file i dont have data column or anything its just a string data in flat file.Can any one please let me know the script
With Regds
Shashi (3 Replies)
Discussion started by: jtshashidhar
3 Replies
4. Shell Programming and Scripting
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... (5 Replies)
Discussion started by: ganesh123
5 Replies
5. Shell Programming and Scripting
Hi Frnds,
I have a flat file with millions of records. .
Now I on this. (I prefer for AWK as its gives good performance.)
Old_file.txt
------------------
1 gopi ase ....
2 arun pl ...
3 jack sutha ..
4 peter pm ..
...
New_file.txt
---------------
4 peter pm ..
..
... (12 Replies)
Discussion started by: Gopal_Engg
12 Replies
6. Shell Programming and Scripting
Hello,
I am strugling from quite a some time to compare flat files with over 1 million records could anyone please help me.
I want to compare two pipe delimited flat files, file1 with file2 and output the unmatched rows from file2 in file3
Sample File1:
... (9 Replies)
Discussion started by: suhaeb
9 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I'm a newbie to scripting and am trying to compare two files using awk.
The files are exactly the same dimensions. Where the first file has 0's I would like to create an updated version of the second file which has the corresponding elements set to zero also.
eg:
file1:
12345 1 2 0... (3 Replies)
Discussion started by: kasan0
3 Replies
8. Shell Programming and Scripting
compare to flat files using awk .but in 4th field contains non ordered substring. how to do that.
file1.txt
john|0.0|4|**:25;JP:50;UY:25
file2.txt
andy|0.0|4|JP:50;**:25;UY:25 (4 Replies)
Discussion started by: veeruasu
4 Replies
9. Shell Programming and Scripting
Hi,
I have got 2 files which i need to compare and append based on the below conditions.
file 1:
File 1 has data in the following format
4300 2356
C234 5689
5500 2345
File 2 has data in the same fomat
4300 49
5555 12345
Now i need to compare the first 4 bytes in each line... (4 Replies)
Discussion started by: roy121
4 Replies
10. Shell Programming and Scripting
Gents,
Can you help please
I have a data base with lot information (file2) and I have some data in (file1) to compare.
Then the comparison should be done using the following keys:
Example ( values from file1 )
key1 = columns from 20-34 substr($0,20,15)
66705.00 19793
key2 = columns... (5 Replies)
Discussion started by: jiam912
5 Replies
LEARN ABOUT DEBIAN
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)