title: Oracle regexp_substr to get first portion of a string
body: <p>I am stuck here. I am using oracle and I want to get the first part of a string before the first appearance of '|'. This is my query but it returns the last part i.e 25.0. I want it to return first part i.e 53. How do I achieve that?</p>
  
  <pre><code>select regexp_substr('53|100382951130|25.0', '[^|]+$',  1,1) as part1 from dual
  </code></pre>