Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove all characters except numbers

3018678Dec 31 2015 — edited Jan 6 2016

Hi All,

I want the following telephone numbers reformat. As you can see from the following, I want to remove all characters except numbers and out 0 at the begining of the number f it doesn't start wirh 0. And the length is 11. What do you recommend?

(543)456-35-50     =>     05434563550

(555)555-55-55     =>     05555555555

(210)111-11-11     =>     02101111111

Thanks
This post has been answered by Frank Kulash on Dec 31 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2016
Added on Dec 31 2015
7 comments
14,432 views