Trim/substring URL address to just file name & extension 1

[davidagnew37]

Hi

I cant seem to find an example to trim or substring an full URL address to just the file name and extension.

for example a variable that holds the address URL:

C:\Reports\Finance\test.rpt

to just return a variable with the file and its extension:

test.rpt

any help would be great.
Thanks

 

[tsuji]

Hello davidagnew37,

If it is a string to string thing, then try something like this.
[tt]
s="C:\Reports\Finance\test.rpt"
a=split(s,"\")
filename=a(ubound(a))
wscript.echo filename
[/tt]
regards - tsuji