Re: Remove non-integer Characters from a column
- From: John Piwowar <jpiwowar@xxxxxxxxx>
- To: oratips@xxxxxxxxx
- Date: Thu, 16 Jan 2014 07:48:19 -0800
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@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
>
Other related posts:
