Split a string at the last delimiter

[tulsantide]

Hi,

I'm trying to split a string at the last delimiter in a vbscript and the following is not working. Please let me know if I'm doing anything wrong.

fname = "C:\Users\userid\Downloads\scripts\test.xlsx"
myarray=Split(fname, "\$",2)
msgbox myarray(0)

I'm expecting the output to be C:\Users\userid\Downloads\scripts

Thanks

 

[SkipVought]

Hi,

fname = "C:\Users\userid\Downloads\scripts\test.xlsx"
myarray=Split(fname, "\")
msgbox myarray(UBound(myarray))

BTW, the Split() function has only 2 arguments.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[guitarzan]

Well, that would give the file name, not the path.

The FileSystem Object can to this without string manipulation:

fname = "C:\Users\userid\Downloads\scripts\test.xlsx"
Set fso = CreateObject("Scripting.FileSystemObject")
msgbox fso.GetParentFolderName(fname)

 

[strongm]

Given you seem to be playing with file and path names, it might make more sense to use the FileSystemObject:

[blue]    With CreateObject("scripting.filesystemobject")
        MsgBox .GetParentFolderName("C:\Users\userid\Downloads\scripts\test.xlsx")
    End With[/blue]

 

[SkipVought]

How did I miss that???

Sorry!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[tulsantide]

Awesome!!..Thank you all!