VB Script Help

[robertdjones]

I am looking for some information on how to manipulate file names in VB. I need to strip extraneous information off of a file name?

Convert a file named 4445555_27_Folder_FileName.tiff into 4445555_27_FileName.tiff (stripping the folder section out).

 

[AHay]

replace("4445555_27_Folder_FileName.tiff", "_Folder","")

For manipulating path names you may want to look at Scripting.FileSystemObject.

You may also want to look at the Split and Instr functions.

 

[FrancisL]

Something like

Function GetFileTitle(fname As String) As String
Dim fso As New FileSystemObject
GetFileTitle = fso.GetFileName(fname)
End Function

You have to have a project reference to Microsoft Scripting Runtime

And there are many other useful things like getting the folder name and much more.