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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
strip_phone.sql
Description: Binary data
