Substr and remove characters from field

What I would like to be able to do is have a unc path with file name like: c:\test\hello\people\file.tif and have a substr command in Oracle remove everything but the filename minus extension. This would have to be able to adapt for different paths and file names.

I have a list of a few hundred file paths in an oracle table I would like to perform this on.

thanks

--
Posted via http://dbforums.com