ASP Question

[kevinj]

I have set up a browse upload function and my advertisers are able to upload their files to my server via a password protected system. I'm also writing the file name to my Access database. My question is how to parse the file name. Currently the whole path from their hard drive gets written to my database. I only want to write the file name (after the last "/") to the database. How can I do this?

Thanks.

[korkus2000]

What language are you using VB, Jscript?

[kevinj]

I'm using VBscript

[RZaakir]

Just take the path and use the InStrRev VBScript function to determine where the first (i.e. last) occurence of a backslash is.

Something like this (off the top of my head, there may be some syntax anomalys):

FullPathname = "C:\dir1\dir2\file.ext"
Filename = Right(FullPathname, (Len(FullPathname) - InStrRev(FullPathname, "\")))

In your code, FullPathname would be whatever variable you have that holds the full file path. The Filename variable would be the actual file name that goes into your database. You could actually do it in one line of code if you substiture FullPathname with your full path.

[kevinj]

Works perfect RZaakir! Thanks.

[RZaakir]

My pleasure Kevin...