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