extract filename from a UNC style path

#1

Hi All,

In AccessXP using Left, Mid, Instr, or whatever works I'm look to
extract just the file name from a UNC style given path as in;

"\\Dfs01\shared\HAN\SHARED1\CLOps\CLCommon\Project sTracker\Apps
\StrStorage.dll"

I've tried several combinations in vba code but failed to extract just
StrStorage.dll......

thanks
bobh.

#2

mid("\\Dfs01\shared\HAN\SHARED1\CLOps\CLCommon\Pro jectsTracker\Apps\StrStorage.dll",instrrev("\\Dfs0 1\shared\HAN\SHARED1\CLOps\CLCommon\ProjectsTracke r\Apps\StrStorage.dll","\")+1)

"bobh" <vulcaned (AT) yahoo (DOT) com> wrote

Quote:

Hi All,

In AccessXP using Left, Mid, Instr, or whatever works I'm look to
extract just the file name from a UNC style given path as in;

"\\Dfs01\shared\HAN\SHARED1\CLOps\CLCommon\Project sTracker\Apps
\StrStorage.dll"

I've tried several combinations in vba code but failed to extract just
StrStorage.dll......

thanks
bobh.

#3

On Sep 12, 5:10*pm, "ron paii" <n... (AT) nospam (DOT) com> wrote:

Quote:

mid("\\Dfs01\shared\HAN\SHARED1\CLOps\CLCommon\Pro jectsTracker\Apps\StrStor*age.dll",instrrev("\\Dfs 01\shared\HAN\SHARED1\CLOps\CLCommon\ProjectsTrack e*r\Apps\StrStorage.dll","\")+1)

"bobh" <vulca... (AT) yahoo (DOT) com> wrote in message

news:d095dbc9-1801-415c-8664-23fe17ad1f19 (AT) bi2g2000vbb (DOT) googlegroups.com...

Hi All,

In AccessXP using Left, Mid, Instr, *or whatever works *I'm look to
extract just the file name from a UNC style given path as in;

"\\Dfs01\shared\HAN\SHARED1\CLOps\CLCommon\Project sTracker\Apps
\StrStorage.dll"

I've tried several combinations in vba code but failed to extract just
StrStorage.dll...... *

thanks
bobh.- Hide quoted text -

- Show quoted text -

Perfect!!! works great!! thanks!
bobh.

#4

On Mon, 12 Sep 2011 16:10:37 -0500, "ron paii" <none (AT) nospam (DOT) com>
wrote:

Quote:

mid("\\Dfs01\shared\HAN\SHARED1\CLOps\CLCommon\Pro jectsTracker\Apps\StrStorage.dll",instrrev("\\Dfs0 1\shared\HAN\SHARED1\CLOps\CLCommon\ProjectsTracke r\Apps\StrStorage.dll","\")+1)

I keep forgeting about instrrev. I also don't recall what version it
was introduced in. Likely in A2000 or A97.

Thanks for the reminder.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

#5

"Tony Toews" <ttoews (AT) telusplanet (DOT) net> wrote

Quote:

On Mon, 12 Sep 2011 16:10:37 -0500, "ron paii" <none (AT) nospam (DOT) com
wrote:

mid("\\Dfs01\shared\HAN\SHARED1\CLOps\CLCommon\Pro jectsTracker\Apps\StrStorage.dll",instrrev("\\Dfs0 1\shared\HAN\SHARED1\CLOps\CLCommon\ProjectsTracke r\Apps\StrStorage.dll","\")+1)

I keep forgeting about instrrev. I also don't recall what version it
was introduced in. Likely in A2000 or A97.

Thanks for the reminder.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

Just discovered it, I needed to extract the extension from file names that
have multiple periods.
Moved from A97 to A2010; Don't think A97 had it.

#6

ron paii wrote:

Quote:

"Tony Toews" <ttoews (AT) telusplanet (DOT) net> wrote in message
news:0mrv67psor4g7qp61ciu1h4ad229i05bbe (AT) 4ax (DOT) com...
On Mon, 12 Sep 2011 16:10:37 -0500, "ron paii" <none (AT) nospam (DOT) com
wrote:

mid("\\Dfs01\shared\HAN\SHARED1\CLOps\CLCommon\Pro jectsTracker\Apps\StrStorage.dll",instrrev("\\Dfs0 1\shared\HAN\SHARED1\CLOps\CLCommon\ProjectsTracke r\Apps\StrStorage.dll","\")+1)

I keep forgeting about instrrev. I also don't recall what version it
was introduced in. Likely in A2000 or A97.

Thanks for the reminder.

Just discovered it, I needed to extract the extension from file names
that have multiple periods.
Moved from A97 to A2010; Don't think A97 had it.

You could get it in A97 by adding a reference to the Windows Scripting
Runtime dll.

#7

"Bob Barrows" <reb01501 (AT) NOSPAMyahoo (DOT) com> wrote in
news:j4q6pu$h0p$1 (AT) dont-email (DOT) me:

Quote:

You could get it in A97 by adding a reference to the Windows
Scripting Runtime dll.

....which is saying that it WAS NOT in A97. I think it was introduced
in the A2002/2003 time frame. Nope, I'm wrong -- it was in A2000.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

extract filename from a UNC style path

comp.databases.ms-access comp.databases.ms-access

extract filename from a UNC style path - 09-12-2011 , 03:43 PM

Re: extract filename from a UNC style path - 09-12-2011 , 04:10 PM

Re: extract filename from a UNC style path - 09-12-2011 , 07:19 PM

Re: extract filename from a UNC style path - 09-13-2011 , 07:02 PM

Re: extract filename from a UNC style path - 09-14-2011 , 07:18 AM

Re: extract filename from a UNC style path - 09-14-2011 , 07:33 AM

Re: extract filename from a UNC style path - 09-15-2011 , 12:47 PM