9 Replies Latest reply on Mar 30, 2016 8:05 AM by venkatesh.sharma

    regex Expression giving incorrect result


      Hi All,


      I have a string  say :  "MY ITEM was placed  in the HOUS"


      I wrote a regex REGEXP_EXTRACT([A-Z]{4}/g ), it is  only giving me  ITEM , but not HOUS.


      It is only giving me first occurance of string. Is there a work around to get all values in a string.

      Rody Zakovich