This discussion is archived
5 Replies Latest reply: Feb 1, 2013 9:18 AM by claudioaragao RSS

how to extract numbers from a text with  regexp_replace

claudioaragao Newbie
Currently Being Moderated
hi guys
I have the following ..... '> 14 413 (4)> 14 567 (1) .....'
and need to extract the numbers to make it so .....

14413
14567

I used this command
REGEXP_REPLACE ('> 14 413 (4)> 14 567 (1)', '\ ([^ ()] * \)','')

and got this response is still not ideal ..
14413> 14567
anyone have any suggestions ...

Thank you ...


I am using oracle 10g r2.

Edited by: claudioaragao on 01/02/2013 07:28

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points