Trim a variable

[Nebooaw]

Hi, i have various variables like;

c:\images\photos\background.bmp
c:\images\temp.bmp

How can i trim everything away and just leave the name of the file and its extension?

ie;

background.bmp

Kind Thanks.

 

[mwolf00]

str = "c:\images\photos\background.bmp"
lastSlash = instrRev(str, "\&quot

str = mid(str,lastSlash + 1) Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048
Tek-Tips Best Practices: FAQ183-3179
It's sad that some Americans proudly turn their backs on the very Flag the gives them the opportunity to do just that... - Mike

 

[Nebooaw]

Cheers, works a treat!

Regards.

 

[PGTurner]

Or another way:

Dim SomeFileSpec, fso
Set fso = CreateObject("Scripting.FileSystemObject")

SomeFileSpec = "\\Somewhere\c$\Inetpub\DischargeSummary\QueryPage.asp"

MsgBox fso.GetParentFolderName(SomeFileSpec)
MsgBox fso.GetBaseName(SomeFileSpec)
MsgBox fso.GetExtensionName(SomeFileSpec)
MsgBox fso.GetFileName(SomeFileSpec)