10-25-2015
I don't see how you get rid of all duplicates by selecting on a few samples???
Are you trying to compare databases? Or, are you trying to compare text files that have been extracted from those databases?
You say the sql server file is larger. How many records are in each database? How many fields are in each database?
If you extracted each entire database into a pipe delimited text file, how many records (lines) would appear in each file and how many characters would be in the longest line in each file?
Please show us a sanitized sample of the records you want to compare and show us the output you want to produce from those input samples? (Please use CODE tags when you post the sample input and output files.)
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi
I need to compare shadow file sizes with their real file counterparts. If the shadow file size differs form the realfile size then it must send a mail. My problem is that our system has over 1600 shadowfiles in different directories, with different names. the only consistancy is the .sh file... (4 Replies)
Discussion started by: terrym
4 Replies
2. Shell Programming and Scripting
So I have two files:
File1
pictures.txt 1.1 1.3
dance.txt 1.2 1.4
treehouse.txt 1.3 1.5
File2
pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244
dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2 ref4948 1.1
treehouse.txt 1.6 ref8573 1.5 ref3284 1.4 ref5838... (24 Replies)
Discussion started by: linuxkid
24 Replies
3. Shell Programming and Scripting
I've two files with data like below:
file1.txt:
AAA,Apples,123
BBB,Bananas,124
CCC,Carrot,125
file2.txt:
Store1|AAA|123|11
Store2|BBB|124|23
Store3|CCC|125|57
Store4|DDD|126|38
So,the field separator in file1.txt is a comma and in file2.txt,it is |
Now,the output should be... (2 Replies)
Discussion started by: asyed
2 Replies
4. UNIX for Advanced & Expert Users
Hi Guys ,
we have one directory ...in that directory all files will be set on each day..
files must have header ,contents ,footer..
i wants to compare the header,contents,footer ..if its same means display an error message as 'files contents same' (7 Replies)
Discussion started by: Venkatesh1
7 Replies
5. Shell Programming and Scripting
I hope I can explain this correctly. I am using Bash-4.2 for my shell.
I have a group of file names held in an array. I want to compare the names in this array against the names of files currently present in a directory. If the file does not exist in the directory, that is not a problem.... (5 Replies)
Discussion started by: BudMan
5 Replies
6. Shell Programming and Scripting
Hi , I want to compare first 3 columns of File A and File B and create a new file File C which will have all rows from File B and will include rows that are present in File A and not in File B based on First 3 column comparison.
Thanks in advance for your help.
File A
A,B,C,45,46... (2 Replies)
Discussion started by: ady_koolz
2 Replies
7. Shell Programming and Scripting
Hi Everyone,
I am comparing results of two environments using unix files.
I am writing two different csv file using spool and merging both the files using paste command
paste -d, file1.csv file2.csv > prod_uat_result.csv
and then finding the difference and attaching the same in a mail... (8 Replies)
Discussion started by: karthik adiga
8 Replies
8. Shell Programming and Scripting
I have 2 files namely branch.txt file & RXD.txt file as below
Ex:Branch.txt
=========================
B1,Branchname1,city,country
B2,Branchname2,city,country
B3,Branchname3,city,country
B4,Branchname4,city,country
B5,Branchname5,city,country
RXD file : will... (11 Replies)
Discussion started by: satece
11 Replies
9. UNIX for Beginners Questions & Answers
Hi,
I have 2 variables as given below. How can i compare them and say its matching ? Appreciate your help
VAR1=describe/read/write
VAR2=read/write/describeThanks,
Please use CODE tags as required by forum rules! (4 Replies)
Discussion started by: prince1987
4 Replies
10. UNIX for Beginners Questions & Answers
I have two file as given below which shows the ACL permissions of each file. I need to compare the source file with target file and list down the difference as specified below in required output. Can someone help me on this ?
Source File
*************
# file: /local/test_1
# owner: own
#... (4 Replies)
Discussion started by: sarathy_a35
4 Replies
LEARN ABOUT SUSE
mail::spf::mod::redirect
Mail::SPF::Mod::Redirect(3) User Contributed Perl Documentation Mail::SPF::Mod::Redirect(3)
NAME
Mail::SPF::Mod::Redirect - SPF record "redirect" modifier class
DESCRIPTION
An object of class Mail::SPF::Mod::Redirect represents an SPF record modifier of type "redirect".
Constructors
The following constructors are provided:
new(%options): returns Mail::SPF::Mod::Redirect
Creates a new SPF record "redirect" modifier object.
%options is a list of key/value pairs representing any of the following options:
domain_spec
See "new" in Mail::SPF::Mod.
new_from_string($text, %options): returns Mail::SPF::Mod::Redirect; throws Mail::SPF::ENothingToParse, Mail::SPF::EInvalidMod
Creates a new SPF record "redirect" modifier object by parsing the string and any options given.
Class methods
The following class methods are provided:
name: returns string
Returns 'redirect'.
name_pattern: returns Regexp
Returns a regular expression that matches a modifier name of 'redirect'.
precedence: returns real
Returns a precedence value of 0.8. See "precedence" in Mail::SPF::Mod.
Instance methods
The following instance methods are provided:
params
See "params" in Mail::SPF::Mod.
domain_spec: returns Mail::SPF::MacroString
Returns the "domain-spec" parameter of the modifier.
process($server, $request, $result): throws Mail::SPF::Result
If no mechanism matched during the evaluation of the current SPF record, performs a recursive SPF check using the given SPF server and
request objects and substituting the modifier's target domain name for the request's authority domain. The result of the recursive SPF
check is then thrown as the result of the current record's evaluation. However, if the target domain has no acceptable SPF record, a
"permerror" result is thrown. See RFC 4408, 6.1, for details.
See Mail::SPF::Mod for other supported instance methods.
SEE ALSO
Mail::SPF, Mail::SPF::Mod, Mail::SPF::Term, Mail::SPF::Record
<http://www.ietf.org/rfc/rfc4408.txt>
For availability, support, and license information, see the README file included with Mail::SPF.
AUTHORS
Julian Mehnle <julian@mehnle.net>, Shevek <cpan@anarres.org>
perl v5.12.1 2010-07-05 Mail::SPF::Mod::Redirect(3)