Jared's passion to regular expessions is understandable after book "Perl for Oracle DBAs" :)
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 02, 2002 8:03 AM > > Yes, but not nearly as flexible as owa_pattern, and infinitely > more difficult to read. > > Jared > > On Monday 01 July 2002 14:33, Kirsch, Walter J (Northrop Grumman) wrote: > > Actually, it's simpler to use the trick > > > > select translate('abc123def432', '~1234567890','~') from dual; > > > > -----Original Message----- > > Sent: Monday, July 01, 2002 4:23 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Yes, use regular expressions via the owa_pattern package. > > > > Here's an example: > > > > declare > > tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882 > > dig2its'; > > begin > > dbms_output.put_line( tstr); > > -- remove the digits > > owa_pattern.change( tstr, '\d', '', 'g'); > > dbms_output.put_line( tstr); > > -- remove the extra spaces > > owa_pattern.change( tstr, '\s+', ' ', 'g'); > > dbms_output.put_line( tstr); > > end; > > / > > > > Jared > > > > > > > > > > > > Nils Höglund <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 07/01/2002 04:18 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > cc: > > Subject: Remove numbers from string > > > > > > > > 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! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev 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).