Brain fart - extracting file name from string

[twoplustwo]

Hi all,

I have this string:

S:\DirectSupply\FinanceReporting\Pricing\Models\Tradebook CSV\WCI00P18.csv

I need to extract the WCI00P18 part.

This is liable to change in length. I've apparently forgotten how to use string functions as of late

 

[DCrake]

Use
Mid(string,InStrRev(String,"\")+1)

By using InStrRev is reads from right to left looking for the first instance of the slash. so everything after the slash is returned by using the Mid() command.

BTW can you rephrase your questions in future without the swear words.

David

 

[twoplustwo]

Thanks DC.

Swear words?

 

[NigelShaw]

Hi

I reckon it might be the "F" word mate

Nidge

 

[MSAccessRookie]

Hi

I reckon it might be the "F" word mate

Nidge

He may have edited the post, but I don't see any "F" words there anymore (unless you meant "FinanceReporting", "forgotten", or "functions").




.

 

[BamaColtsFan]

He meant in the title of the post...

 

[MSAccessRookie]

He meant in the title of the post...

I see what you mean. I guess that it went right past me, because that phrase has become so common that I did not consider it to be a form of swearing.

 

[twoplustwo]

Swearing?!



Apologies if I've offended.

 

[MarkK]

You can also use the 'GetBaseName' method of the Scripting.FileSystemObject, which drops the extension too...

With CreateObject("Scripting.FileSystemObject")
  Debug.Print .GetBaseName("S:\DirectSupply\FinanceRep...book CSV\WCI00P18.csv")
End With

FSO provides a bunch of methods for working with names