That's an interesting idea, thanks, Kees. -----Original Message----- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 2:57 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Function question
Hi Jim, On Thu, 1 Feb 2007 09:08:44 -0500, you wrote: >From the CLP (i.e., w/o user-defined functions) is there any way to get >the equivalent of the sybase ltrim, rtrim functions? (ltrim/rtrim trim >spaces from the right/left end of a column value.) As far as I can tell load_extension(X,Y) can be used in the command line program. I usually postprocess output by piping it through awk to solve these kinds of problems. sqlite3 databasefile <sqlscript | awk -f trim.awk >outfile >jim HTH -- ( Kees Nuyt ) c[_] ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- -------------------------------------------------------- NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
