I have many strings that I need to tokenise - an example is shown below.

```
NAME:ALAN GREYINTACC:999ACCOUNT:12345678SORT:654321REF:ABC 7654321

```

I can use a combination of `INSTR` and `SUBSTR` to do this, but I was hoping that there might be an easier way to perform this using `REGEXP_SUBSTR`.

I've looked at anchors, but could only find references to start string `^` and end string `$`. 

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 `ACCOUNT:` and before `SORT:`

Any replies appreciated,

Many Thanks