title: How to change from regexp_extract to regexp_substr in Snowflake
body: <p>I have some expressions in Hive that I need to change into Snowflake</p>
  <p>(regexp_extract(subtransactionxml,'(.*?)()',1) in('REFUND'))</p>
  <p>I tried to use this one but it gives me 0 results</p>
  <p>(regexp_substr(subtransactionxml,'\W+(\W+)',1,1,'e',1) in('REFUND'))</p>
  <p>Where is my mistake?</p>