Keith Clark wrote:
Barbara Duprey wrote:
Keith Clark wrote:
norseman wrote:
Keith Clark wrote:
I need to remove all ACII 13 characters from a field in a
database. Each entry could have multiple ASCII 13 characters. Is
there a way to do this?
<snip>
With nothing else to go on:
for each field
read it
go through the field character by character and concat all
non ASCII 13 to a variable.
replace the field with the variable.
Without knowing the OS, the specific database and such, that is the
best I can offer.
Steve,
The database is Open Office Base. The OS should not matter.
Keith
Base supports using SQL commands to update fields; I don't have the
specific syntax handy, but I know it can be done quite simply. I'm
not sure how the ASCII 13 would be represented for the command, and
it may be affected by what the database engine is that is accessing
the data. Is this an embedded database (i.e., HSQLdb) or is it being
connected to?
mysql remote database.
Keith
Tools > SQL from the Base main menu allows entry of SQL commands that I
believe are passed through unchanged to the database engine, so if you
can determine the syntax for the appropriate mysql UPDATE - SET command
you should be able to get the job done very easily. If you can't, I'd
recommend asking [EMAIL PROTECTED] or [EMAIL PROTECTED] --
those are the lists where the Base folks are most likely to hang out, if
you don't get an answer here.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]