Re: Remove non-integer Characters from a column

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Thu, 16 Jan 2014 09:41:59 -0600
Message-ID: <CAP79kiQC8Qe2WA4n0RTmMNnaX1N699yPKX+YSuxFeQnyLxJ1fQ_at_mail.gmail.com>



Take a look at REGEXP_REPLACE:

update table_name
set column_name = regexp_replace(column_name, ..., .....);

Need to be familiar with regular expressions though to get the most out of it.

HTH
Chris

On Thu, Jan 16, 2014 at 9: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:41:59 CET

Original text of this message