Parse file name out of path 5

[roswald]

My dear friends I can do this in a few other languages with no problem but doing it in VB has me stumped.
How can I get 'MyFile' out of a string that has filename and path? i.e. 'J:\downld\fldr\another\MyFile.txt'

I am really stumped, please show me the way!

Thanks for your help

 

[Swi]

Dim Test As String
Dim TestFileNamePos As Integer
Test = "J:\downld\fldr\another\MyFile.txt"
TestFileNamePos = InStrRev(Test, "\&quot
MsgBox Mid$(Test, TestFileNamePos + 1) Swi

 

[TheTuna]

Thanks for a better way... I've been doing it the hard way. Tuna - It's fat free until you add the Mayo!

 

[strongm]

Or even:
[tt]
Dim fso As Object
Set fso = CreateObject("scripting.filesystemobject&quot
MsgBox fso.GetFileName("J:\downld\fldr\another\MyFile.txt&quot

 

[TheTuna]

This is why I can't leave this place for more than 5 minutes... there's always more than 1 way to skin a filename... in all my years of coding, I've never been so happy with a resource as I am now.

thanks for two good solutions, both of which I never thought to use, because my way "worked" and i never needed to change it. Tuna - It's fat free until you add the Mayo!

 

[vb5prgrmr]

How about a one liner?...
[tt]
Dim S As String
S = "J:\downld\fldr\another\MyFile.txt"
MsgBox Mid(S, InStrRev(S, "\&quot + 1)
[/tt]

This just combines what SWI does above into one line.

 

[roswald]

Thanks experts! All excellent code solutions. I appreciate your help.

Roswald

 

[ericksoda]

I had trouble using
fso.GetFileName "J:\downld\fldr\another\MyFile.txt&quot

because it only works if the file actually exists.

David

 

[strongm]

<bzzzt> wrong, I'm afraid. GetFileName doesn't care whether the file exists or not. I happen to know this, but just for the record here is part of the helpfile entry:
[tt]
The GetFileName method works only on the provided path string. It does not attempt to resolve the path, nor does it check for the existence of the specified path.

 

[ADoozer]

id like to star you all but vb5prgrmr has stole my vote...

 

[strongm]

You can vote more than once...

 

[roswald]

How do you vote? This thread deserves recognition.

 

[johnwm]

At the bottom left of each individual post is a shortcut (link) that says ' Mark this post as a helpful/expert post!'

Just click the link!
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[strongm]

It's probably worth pointing out that the FSO solution deals with common typos (e.g. using / instead of \ as a path seperator) and with URLs. So:

MsgBox fso.GetFileName(&quot;J://downld\fldr/another\MyFile.txt&quot

works, as does

MsgBox fso.GetFileName(&quot;thread222-432765

 

[koukouroukou]

strongm is right the best solution for file manipulation is file system object.

 

[strongm]

Ooh - tek-tips ate the URL in the example code. Bah!