Search Results

Some comments:

If you try to write MySQL-Functions, I suggest starting from a very minimal function and extend bit by bit and checking if the results are as expected at every step. So you can...

Hi,

maybe you create a function which figures out the count of equal numbers from the left. Let it for example be called: "get_equal_numbers(col_number,my_number)" See here fore documentation:...

Closest match can have several meanings... Assuming that you mean you want the longest string in File1 that is a leading substring of the string in File2, you could also try this slightly different...

This one strips off more and more digits from the end until it finds a match
awk '
NR==FNR {
# file1
s1=$1
$1="" # this changes $0
s[s1]=$0
next
}
{
# file2
len=length($1)
...

if you want to use Perl for predefined date you can use below code:-


#!/usr/bin/perl -l

use Date::Parse;
print str2time("Mon Apr 18 16:45:00 UTC 2011"); #1303145100
print...

it is more simpler if you use associative array below:-

Note:- in solaris use nawk instead of awk.


awk 'NR==FNR{a[ int( substr($0,1,9) )] ; next}(FNR in a)' fileA fileB


BR
...