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?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
mysql remote database.
Keith
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]