T&B wrote:
Last month, Mikey C wrote (in part):
I've had these functions hanging around for some time... if anyone
wants the code, please take it.
I have all the code as a MS Visual Studio 2003 project. It is based
on source code 3.3.5
replace(X,Y,Z) Returns the string X with every occurence of Y
replaced by Z.
rightstr(X,Y) Returns the Y last characters of the string X.
strfilter(X,Y) Returns the string X with the characters not in Y
removed.
trim(X) Returns a string equal to X but with all the whitespaces at
the begining and at the end removed.
median(X) Returns the value of the group such that the number of
elements smaller is equal to the number of larger elements.
mode(X) Returns the most frequent value in the sample X.
stdev(X) Returns the standard deviation of the sample X.
http://www.nabble.com/file/6285/SQLite.zip SQLite.zip
--
View this message in context: http://www.nabble.com/Extension-
functions-for-SQLite-in-C-for-free-tf3182921.html#a8833684
For the non-C programmer (but with access to standard UNIX C compile
tools etc), can someone please explain or point to a step by step
procedure to add these functions so they are accessible within the
sqlite3 shell command?
Thanks,
Tom
This requires that you produce a custom version of the sqlite3 shell
incorporating the extra functions. That requires some basic programming
understanding.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
