hello all,
I have requirement to identify similar records matching about 80% to 90%.I have to black list customers with multiple accounts.
The data is in the Oracle Database, but is there any way I can get the data into flat file and compare the strings and fetch similar matching records?
I have one table with
I need to pull out name and address fields similar. And spaces or slight difference can be ignored. I have tried within database methods which is very slow. And I have only basic knowledge of shell scripting need help for a way to get compared result faster. I have very large data to compare..more than 10 millions..
Last edited by Scrutinizer; 10-17-2013 at 04:47 PM..
Reason: code tags
Hi,
I have a file with 6 columns. First 3 columns together make unique record. I have a variable ($v) which hold a value that is obtained by a caliculaion. I have to replace value in 5th columnn with the value of the variable ($v). The value $v is caliculated from col4 and col6 values.
... (2 Replies)
i am reading an i/p file input.txt as below and want to read all filenames as in highlighted in bold below and put them in a different file output.txt. can someone help me with a shell script to do this? thanks in advance
regards
brad
input.txt
---------
START
TYPE:OPT
INIT_SEQ:01... (8 Replies)
I have a text file in the following format. can any one please help me in printing the output in userfriendly format mentioned below.
Input.
1) /ss/abc/1/w/s/domainname/abc1/logname/
########error###################
########error###################
########error###################... (2 Replies)
Hi,
I have a file with the lines as below:
C_10_A05_T7
C_10_A06_SP6
C_10_B05_SP6
C_10_B05_T7
C_10_B01_SP6
C_10_B01_T7
C_12_G07_SP6
C_12_G11_SP6
C_12_G11_T7
C_2_H18_T7
C_2_I02_SP6
C_2_I02_T7
C_2_I13_SP6
C_2_I17_SP6
The four segments of each line are connected by '_' symbols. I... (7 Replies)
hi all,
i want script to print the output in the following format
filename yyyy/mm/dd count
where count= no.of records in the file
Thanks in advance
hemanthsaikumar (11 Replies)
I am trying to Join all the lines matching similar pattern.
Example ;
I wanted to join all the lines which has sam to a single line.
In next line, i wanted to have all the lines with jones to a single line....etc
> cat sample.txt
sam 2012/11/23
sam 2012/12/5
sam 2012/12/5
jones... (2 Replies)
Hello Mates,
I would request your help in a shell script,
simply I need to delete some matching db table records (rows) to ones in a given file:
------------------------------
#!/bin/bash
SQL="delete from numberlist where msidn='';"
MYSQL_USER="<your-user>"... (4 Replies)
Not sure if this is the correct forum for this question. I have two files. file1.zip, file2
Input:
file1.zip
col1, col2 , col3
a , b , 0:0:0:0:0:c436:9346:d40b
x, y, 0:0:0:0:0:880:39f9:c9a7
m, n , 0:0:0:0:0:80c7:9161:fe00
file2.txt
col1
c4:36:93:46:d4:0b... (1 Reply)
Discussion started by: anil.v
1 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)