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

This message: [ Message body ]
Next message: mandarkraftware_at_gmail.com: "Available SAP SD CRM and Siebel/Actuate consultant with us..................."
Previous message: Thomas Olszewicki: "Re: Oracle JDBC connection class (10.1 vs 10.2)"
In reply to: Vijay: "eliminate the characters which are not in the specified list of characters"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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