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!

REGEXP_SUBSTR to extract between last slash and first number

John MCGrathJan 21 2025

I'm trying to extract a substring from the full string and having trouble.

from this

/hd/prod/batch/files/ECM/print/final/duplex/StandardCENT01192025085550_2_7.pdf

I would like to get just the bold portion. StandardCENT

I've been able to get everything after the last slash but can't seem to figure out how to not get from the start of the numerics to the end.

Thanks.

This post has been answered by BluShadow on Jan 21 2025
Jump to Answer
Comments
Post Details
Added on Jan 21 2025
6 comments
543 views