RE: Remove numbers from string

From: Ferenc Mantfeld <fmantfeld_at_siebel.com>
Date: Mon, 01 Jul 2002 17:27:13 -0800
Message-ID: <F001.0048D717.20020701172713@fatcity.com>

Nils

I wrote this function some time ago, when our CTI application was crashing because it found telephone numbers to dial like 1-800-Dial-a-prayer or '(800)-555 1234', so I wrote this function to replace any non-alphanumeric characters with nulls and any letters on the dial pad with the corresponding numbers. You can adapt it for yourself to suit. It runs pretty fast on even millions of rows. Cheers :

Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
Only Robinson Crusoe had all his work done by Friday

-----Original Message-----
Sent: Monday, 1 July 2002 4:18 AM
To: Multiple recipients of list ORACLE-L

Is there any way to remove all numbers from a string?

The string might look like this: 'abc123def432' and I wan't it to look like this: 'abcdef'.

I'm using Oracle 8.

Thanks in advance!

--

/Nils Höglund, Naqua KB

E-mail:         nils_at_naqua.se
Web:            http://www.naqua.se/
Home Phone:     +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:        Nya Valsätrav. 26 B
                SE-756 46
                Uppsala, Sweden

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  INET: nils_at_naqua.se

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ferenc Mantfeld
  INET: fmantfeld_at_siebel.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jul 01 2002 - 20:27:13 CDT