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

    regex Expression giving incorrect result

    venkatesh.sharma

      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