Re: Remove non-integer Characters from a column

From: John Piwowar <jpiwowar_at_gmail.com>
Date: Thu, 16 Jan 2014 07:48:19 -0800
Message-ID: <CAJgcjAA-tHYyoybb6RyFvHw=iZqySKi3yJiWLLxFD4jopxOSiw_at_mail.gmail.com>

I am 95% certain (full confidence requires a doc check) that you can accomplish this with regexp_replace().

On Thu, Jan 16, 2014 at 7:38 AM, Bala <oratips_at_gmail.com> wrote:

> Gurus,
>
> Oracle 11..2.0.3 on Linux R6
> ==
> 1) I have a field with a data type of varchar2 that has integers and
> non-integer characters.
> 2) Example: 214’ or 61+45 or 88/8.
> 3) How can i remove the non-integer characters from the table ?
> 4) Can a function be written to remove non-integer characters ?, so in the
> example it would be 214 or 6145 or 888
> ==
>
> Appreciate any pointers to solve this, thank you in advance.
>
> Sincerely
>
> --
> Bala Rao
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 16 2014 - 16:48:19 CET