Re: Remove non-integer Characters from a column

Thank you very much for pointing this out. I will explore all the options.

thanks again for super prompt reply.

Best
Bala

On Thu, Jan 16, 2014 at 9:41 AM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> 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
>>
>
>

-- 
Bala Rao

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