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: eliminate the characters which are not in the specified list of characters

Re: eliminate the characters which are not in the specified list of characters

From: Thomas Kellerer <JUAXQOSZFGQQ_at_spammotel.com>
Date: Fri, 15 Jun 2007 15:54:33 +0200
Message-ID: <5dfk0pF32ajdfU1@mid.individual.net>

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

Original text of this message

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