Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Substr and Instr

GUS CRIGHTON2 days ago

Hi

I have a string that I need to split but this is driving me crazy

P255721Q1D25092025

Needs to be split into 3 fields

1 after the P but before Q (can be different lengths)

2 after Q but before D (can be different lengths)

3 after D (always the same length. It is a date)

Any help appreciated

Reagrds

Gus

This post has been answered by F.Eicken on Oct 8 2025
Jump to Answer
Comments
Post Details
Added 2 days ago
4 comments
55 views