REGEXP_SUBSTR get number
Hello,
I want to extract a number from a string that is always at the same position. The string looks e.g. like 'lkjsd.d.23.doc33-i-99.doc'. I want to get the number which is always before '.doc'. I know I could do that with a regexp_substring [[:digit:]]+.doc$ (with $ I know its at the end of the string) and I get '99.doc' and put the result into another regexp_substring [[:digit:]]+ with that I get '99'.
Could I do that with one regexp_substring expression? How could I pimp that?
thx