Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Use of INSTR to strip directory and extension from file
I would propose you look into the regexp-functions. For instance
regexp_substr():
select regexp_substr(regexp_substr('c:\Program Files\A Directory\File1.file','[^/\]+$'),'^[^.]+') from dual
br,
stephan
Received on Wed Feb 15 2006 - 10:24:11 CST