Oracle has an INSTR function which would return the first position of a match so Substring of field to INSTR colon position -1