Parse through a String Value to extract only numeric values

I have a situation on where I am receiving information or data from a vendor or third party. The problem is that they have a front end free form field that is designated for a phone number. I need to be able to parse through this field of data and only extract numeric data. So for an example, if I am given a free form value of:

Example A:
1 (404) 653-9832

End Result to Extract:
14046539832

Is there an efficient way about going about this? I have no access or control on the vendors side to locking down the format on the front end. I am currently working on 11g Oracle database.

Thank You!
SeaghostAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Try this:
regexp_replace('1 (404) 653-9832','[^[:digit:]]')
0
 
SeaghostAuthor Commented:
Let me give it a try.
0
 
SeaghostAuthor Commented:
Yes, I think this can resolve my issue. Thank You So much slightwv.
0
 
SeaghostAuthor Commented:
Wonderful service like always.
0
 
slightwv (䄆 Netminder) Commented:
Glad to help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.