I'm on an Oracle 12c database; I have a column of data with values resembling this: HL7_Result_for_Message_ID_123Q324343.hl7 I need to grab that ID number (in bold), the challenge being that it ...

I am not getting any oracle errors, just the padding on the right that wont go away. I have tried the sub select and got the same result. I will try substr and get back to you.