Re: Substr and remove characters from field

jakemoore <member34054_at_dbforums.com>

> 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.

Does a UNC path not have the server name instead? How can the path be universal if you locallised it to a specific drive?

A UNC path looks something like this :
\\servername\sharename\foldername\filename

--
Billy