5 Replies Latest reply: Feb 1, 2013 11:18 AM by claudioaragao RSS

    how to extract numbers from a text with  regexp_replace

    claudioaragao
      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