John Toliver wrote:
On Fri, Dec 19, 2008 at 13:16, Drew Jensen <[email protected]>wrote:
Rainer Schuetz wrote:
On 19.12.2008, at 17:48, John Toliver wrote:
JT - I wasn't sure what other information to provide. But I'm running
Openoffice 3, Base. Using the standard HSQLDB for the backend. Using
GNU/Linux 2.6.24-21-generic.
So you might want to check online-documentation for HSQLDB (google it up,
you might even try HSQLDB TRIM RTRIM)
Oh give google a day off and try this:
http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#String_Functions
I went to the above site and have been trial and erroring with the rtrim
command in the SQL command window. I get the following errors:
I enter in this: RTRIM( ' . ' ) - I'm trying to tell it to remove all
trailing spaces in any field after the last period.
I receive this error:
1: Unexpected token: RTRIM in statement [rtrim]
So what do I need to do to make sure this command is executing on the right
table/query?
I think you need something like this in the SQL command window:
UPDATE 'your_table' SET 'your_field' = RTRIM('your_field')
By definition, the RTRIM function will create a string that removes all
the spaces from the end of the original string back to the last
non-space character, whatever that is, and since you're storing the
result back into the field, it should do what you want, I think. You
might want to check it out in a copy of your table, though -- these
update operations can do really wonderful things, but if they go wrong
they can do an awful lot of damage!
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
