Re: Remove non-integer Characters from a column
- From: Bala <oratips@xxxxxxxxx>
- To: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>, John Piwowar <jpiwowar@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Jan 2014 09:51:23 -0600
Gurus,
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@xxxxxxxxx> 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@xxxxxxxxx> 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
Other related posts:
