On Thu, 30 Oct 2008 08:31:19 +1300 Came this utterance fomulated by Michael Adams to my mailbox:
> 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. > Sorry make that 0x0A for unix, OS X and linux. Mac OS < 10 were 0x0D. -- 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]
