title: How to use Oracle 10g REGEXP_SUBSTR to extract a string using a string delimiter
body: <p>I have many strings that I need to tokenise - an example is shown below.</p>
  
  <pre><code>NAME:ALAN GREYINTACC:999ACCOUNT:12345678SORT:654321REF:ABC 7654321
  </code></pre>
  
  <p>I can use a combination of <code>INSTR</code> and <code>SUBSTR</code> to do this, but I was hoping that there might be an easier way to perform this using <code>REGEXP_SUBSTR</code>.</p>
  
  <p>I've looked at anchors, but could only find references to start string <code>^</code> and end string <code>$</code>.  </p>
  
  <p>Is there such a thing as an 'in string' anchor? e.g. If I wanted the account number from this string, I want everything after <code>ACCOUNT:</code> and before <code>SORT:</code></p>
  
  <p>Any replies appreciated,</p>
  
  <p>Many Thanks</p>