10-19-2010
The answer is that you probably have unnecessaily complex perl code; yes, awk, perl or some other languages all work well. We have searches like that on 10M rows that take less than 2 minutes.
Please give us a few sample rows, sample output, and point out the field that is the primary key.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi Guys,
Requirement: Want to compare two files, if the the content of both files is same then show "Good result" else Show "Bad Result"
I am using the following logic
if( cmp -s a b = 0 )
then
echo "Good result"
else echo "Bad result"
exit 0
fi
But this is... (1 Reply)
Discussion started by: abhishek3598
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I need to compare 2 files based on the first field in each file and output the differences to a new file.
example File 1 and File 2 both have first field as Number ie:
File 1
1252652355
1859553322
1778899562
File 2
1252652355
1859553322
So I would expect File 3 to... (2 Replies)
Discussion started by: Lagre1
2 Replies
3. Shell Programming and Scripting
Hi Friends,
I have a requirement like i have two files in diffrent locations. i want to compare these two files, if both the files are same i want to return "0" else return 1.
Please help me on this.
Thanks
sreenu. (3 Replies)
Discussion started by: sreenu80
3 Replies
4. UNIX for Dummies Questions & Answers
how can i unix compare two files??
var1 = 6499 7328 6351 7583 7573
var2 = 6499 7328 6351 7583 7777
i did:
diff $var1 $var2
and i got the output:
1c1
< 6499 7328 6351 7583 7573
---
> 6499 7328 6351 7583 7777
what can i do with it? and what does it tell me?? how can i knoe that... (2 Replies)
Discussion started by: nirnir26
2 Replies
5. Shell Programming and Scripting
Hi Gurus
I need your kind help sorting the below query
I have two text files
File1.txt
ID Name Address
101 Srinath BBB
102 Sidharth CCC
File2.txt
ID Name Address
102 Siddharth DDD
103 Suman EEE
Now the requirement is if the second file has... (0 Replies)
Discussion started by: Pratik4891
0 Replies
6. Shell Programming and Scripting
Hi,
I have two files
File1 Contents:
abc
dcf
sdc
File2 Contents:
dcf
sdc
erg
Now my program should return the contents existing in File1 but not in File2. In this case output shoud be "abc" as abc is not available in File 2. It should not return "erg" by saying it is... (4 Replies)
Discussion started by: forums123456
4 Replies
7. UNIX for Dummies Questions & Answers
Hello,
I have a dat file nctilllist.dat which will be present in the directory path
"/usr/lpp/web-data/mfg/nct/file-data/nctilllist.dat"
nctillist.dat will have reference to files like DP100001.jpg,DP10002.PDF,DP100003.doc
on the path /usr/lpp/web-data/mfg/nct/file-data will have... (12 Replies)
Discussion started by: gayathrivm
12 Replies
8. Shell Programming and Scripting
I have a file containing the below data obtained after running a diff command
> abc 10
< abc 15
> xyz 02
<xyz 05
.....
Does anyone know how i can obtain output like :
previous value of abc is 10 and present value is 15
similarly for all the comparisons in the text file (10 Replies)
Discussion started by: amithpatrick1
10 Replies
9. Shell Programming and Scripting
I have requirement to compare two files in unix. Below are the sample files.
File1:
cn=test123,cn=bobgroup,dc=ind,dc=com
cn=bob123,cn=bobgroup,dc=ind,dc=com
cn=test13,cn=bobgroup,dc=ind,dc=com
cn=est12,cn=bobgroup,dc=ind,dc=com
cn=st123,cn=bobgroup,dc=ind,dc=com
File2... (1 Reply)
Discussion started by: babu92
1 Replies
10. Shell Programming and Scripting
Hi,
I have below query related to multiple file comparing
I have four files i want to compare it and contents of one file will not be presence in 3other files and if any content found then it will print the execution.
Can you please help me how to achieve it. (2 Replies)
Discussion started by: soumyamihp
2 Replies
LEARN ABOUT DEBIAN
imager::preprocess
Imager::Preprocess(3pm) User Contributed Perl Documentation Imager::Preprocess(3pm)
NAME
Imager::Preprocess - simple preprocessor for handling multiple sample sizes
SYNOPSIS
/* in the source: */
#code condition true to work with 8-bit samples
... code using preprocessor types/values ...
#/code
# process and make #line directives
perl -MImager::Preprocess -epreprocess foo.im foo.c
# process and no #line directives
perl -MImager::Preprocess -epreprocess -l foo.im foo.c
DESCRIPTION
This is a simple preprocessor that aims to reduce duplication of source code when implementing an algorithm both for 8-bit samples and
double samples in Imager.
Imager's "Makefile.PL" currently scans the MANIFEST for .im files and adds Makefile files to convert these to .c files.
The beginning of a sample-independent section of code is preceded by:
#code expression
where expression should return true if processing should be done at 8-bits/sample.
You can also use a #code block around a function definition to produce 8-bit and double sample versions of a function. In this case #code
has no expression and you will need to use IM_SUFFIX() to produce different function names.
The end of a sample-independent section of code is terminated by:
#/code
#code sections cannot be nested.
#/code without a starting #code is an error.
The following types and values are defined in a #code section:
o IM_GPIX("im", "x", "y", &col)
o IM_GLIN("im", "l", "r", "y", "colors")
o IM_PPIX("im", "x", "y", &col)
o IM_PLIN("im", "x", "y", "colors")
o IM_GSAMP("im", "l", "r", "y", "samples", "chans", "chan_count")
These correspond to the appropriate image function, eg. IM_GPIX() becomes i_gpix() or i_gpixf() as appropriate.
o IM_ADAPT_COLORS("dest_channels", "src_channels", "colors", "count")
Call i_adapt_colors() or i_adapt_fcolors().
o IM_FILL_COMBINE("fill") - retrieve the combine function from a fill object.
o IM_FILL_FILLER("fill") - retrieve the fill_with_* function from a fill object.
o IM_SAMPLE_MAX - maximum value for a sample
o IM_SAMPLE_MAX2 - maximum value for a sample, squared
o IM_SAMPLE_T - type of a sample (i_sample_t or i_fsample_t)
o IM_COLOR - color type, either i_color or i_fcolor.
o IM_WORK_T - working sample type, either int or double.
o IM_Sf - format string for the sample type, "%d" or "%f".
o IM_Wf - format string for the work type, "%d" or "%f".
o IM_SUFFIX(identifier) - adds _8 or _double onto the end of identifier.
o IM_EIGHT_BIT - this is a macro defined only in 8-bit/sample code.
Other types, functions and values may be added in the future.
AUTHOR
Tony Cook <tonyc@cpan.org>
perl v5.14.2 2011-06-06 Imager::Preprocess(3pm)