Skip to Main Content

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!

Function to extract a phone number from an address?

687520Oct 21 2010 — edited Oct 22 2010
Hello,

I need to implement a function that is able to extract an US/Canadian phone number (in a variety of formats) from an address.
For example I need to extract the phone number from a string like:

Mr. A. Johnson
J & Son Inc.
123 Front st.
tel: (613) - 123 -1234 ext.216

The function should return *(613) - 123 -1234*

Any help will be greatly appreciated.

Regards,
M. Rusu
This post has been answered by MichaelS on Oct 22 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2010
Added on Oct 21 2010
8 comments
1,392 views