title: Please help me with regexp_substr in snowflake
body: <p>In snowflake below is the regex for seperating strings based on &gt;&gt; but when data is with space it is not doing so I mean it is taking partial value not compete value</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT replace(REGEXP_SUBSTR( 'test1 &gt;&gt; test2 &gt;&gt; test3','([^&gt;]*)([[:space:]]&gt;&gt;[[:space:]]|$)', 1,1 ) , ' &gt;&gt; ','') as test;
  
  SELECT replace(REGEXP_SUBSTR( 'test1 &gt;&gt; test2 &gt;&gt; test3','\\w+([[:space:]]&gt;&gt;[[:space:]]|$)', 1,1) , ' &gt;&gt; ','') as test;
  </code></pre>
  <p>I have data like this
  'test value &gt;&gt; test1 &gt;&gt; test2'
  But above regex is only giving as value but I want complete 'test value'  can anyone help me on this?</p>