On Thu, 30 Oct 2008 05:45:05 +0000, "Drew Jensen" <[EMAIL PROTECTED]> wrote: >>-----Original Message----- >>From: Keith Clark [mailto:[EMAIL PROTECTED] >>Sent: Wednesday, October 29, 2008 04:16 PM >>To: [email protected] >>Subject: Re: [users] Base field alter >> >>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> >>>>> >>>>> Without knowing the OS, the specific database and such, that is the >>>>> best I can offer. >>>>> >>> >>> >>mysql remote database. >> > > MySQL ( and pretty much every other SQL database) supports the REPLACE > function, see: > http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace > > As Ms. Duprey mentioned in an earlier response in order to use this in an > UPDATE statement, under Base, you will need to do so in the SQL window. > 'Tools>SQL'. > > To look for the ASCII 13 character you will use the function CHAR(13) - > so to replace ASCII 13 with a SPACE the command will be something similar > to > > UPDATE 'your_table' SET 'your_column' = REPLACE( 'your_column', CHAR(13), > ' ' );
Thanks Drew! That is exactly what I need. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
