Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

REGEXP question

469875Jun 17 2007 — edited Jul 10 2007
HI ALL,

how do i extract from 'A1B2C3-AZ123' the characters A-Z after the '-' ?

i tried to use:
select regexp_substr('A1A1A1-AZ11', '-[A-Z]+') from dual
but this still returns '-AZ' including the '-' :(

i may want to omit the '-' and capture 'AZ' only.

i tried another substr to omit the '-', but can we do this as a single regexp? :)

help on this one pls :)

THANKS!
BROKEN

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 7 2007
Added on Jun 17 2007
11 comments
1,437 views