Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help on Removing "Junk" Characters

Re: Help on Removing "Junk" Characters

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 18 Oct 2005 19:47:54 +0200
Message-ID: <dj3bvq$3be$3@news2.zwoll1.ov.home.nl>


Robert wrote:
> 10g
>
> Please help with this:
>
> How to write an UPDATE where REGEXP_REPLACE (or something else) can be used
> to replace any non-alphanumeric characters with NULL ?
>
> Several records have data that look like this:
>
> customer.companyname
> --------------------------------------------------
> Pericles Comidas cl�cas Guillermo Fern�ez
> Queen Cozinha L�cia Carvalho
> Supr�s delices
>
>
> Thanks
>
>

I would be careful with that.
Most likely these are not junk characters, but your front end fails to recognize them, and thus displays junk.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Tue Oct 18 2005 - 12:47:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US