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