Using "regexp_substr" to get filname from a path
34277Nov 22 2005 — edited Jul 8 2008I'm trying to use "regexp_substr" to get the filename from a path. I thought this should work:
select regexp_substr('C:\Documents and Settings\RipHard\Desktop\mantis_logo.gif', '^(.*\\)(.*)'
, 2) from dual;
However it returns NULL.
I'm obviously missing something here. How can you specify this expression so it will return the filename "mantis_logo.gif" on its own?