SQL Oracle: Finding / Parsing numerical string out of text field
Posted on 2011-09-27
I have a table ie temp_memo which has one column called memo.
typical values are
"called number (123-456-7890) then spoke to bob with account number (123456)"
"account number 123456, number that dial was 1234567890 name was bob"
"account number 123456, number 123-456-7890 bob called to"
"bob called his number was (1234567890), caller id number is 123456"
Basically I want to create a script that isolates and populates on the phone number in the format
Ideally I would like to do in SQL but I have other tools at disposal such as excel.
Any help would be greatly appreciated.