title: Split delimited string in SAP HANA
body: <p>I am using HANA 1.0 SPS12. Is there a way to split delimited string in SAP HANA.</p>
  
  <p>I have Pipe delimited string as - </p>
  
  <pre><code>v_input = '1111|2222|3333|4444'
  </code></pre>
  
  <p>I need output base on position of delimited part -</p>
  
  <pre><code>select seperate_string(v_input,pos) from dummy;
  </code></pre>
  
  <p>for e.g.</p>
  
  <pre><code>select seperate_string('1111|2222|3333|4444',1 ) from dummy; --1111
  select seperate_string('1111|2222|3333|4444',2 ) from dummy; --2222
  select seperate_string('1111|2222|3333|4444',3 ) from dummy; --3333
  </code></pre>
  
  <p>Is it possible to do this with <strong>SUBSTR_REGEXP</strong>?</p>
  
  <p>I tried below coded but it did not work -</p>
  
  <pre><code>select SUBSTR_REGEXPR('[^\|]+' IN '1111|2222|3333|4444' GROUP 1 ) from dummy;
  </code></pre>