On Wed, 29 Oct 2008 14:05:02 -0400 Came this utterance fomulated by Keith Clark to my mailbox:
> 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? > >> > > 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. > > The database is Open Office Base. The OS should not matter. > Not sure if an enter is stored in unix format 0x0D only or windows format 0x0D0A format but if you have access to find and replace in the database then regular expressions are your friend. Can't be more help sorry, because i don't use the database. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
