3 Replies Latest reply: Dec 13, 2012 7:01 AM by 979750 RSS

    Regular Expression query

    979750
      We will have below data in one column

      ++77++
      ++34_
      --9--
      98
      999
      +00_

      My requirement is to fetch only number from above data. please find output i want from each data

      ++77++ -> 77
      ++34_ -> 34
      --9-- -> 9
      98 -> 98
      999      -> 999
      +00_     -> 00


      Please provide the query for the same.

      Thanks