Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: eliminate the characters which are not in the specified list of characters
On 15.06.2007 12:50 Vijay wrote:
> I want to display the character from the selected list only.
> i want to eliminate the characters which are not in the specified list
> of characters
>
> For expamle...
> Specified list of characters: (a-z 0-9),
>
> my input string is: test for string
> output string should be : testforstring
>
You can use regexp_replace()
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions130.htm#i1305521
Thomas Received on Fri Jun 15 2007 - 08:54:33 CDT
![]() |
![]() |