check out REGEXP_INSTR, you would basically need to find the position of the | and then take the field starting at position X for a length of Y