Parsing the last "\"

[IS300]

I would like to get the directory and the filename of the entire file path when a user enters it into a form.

So, if the filename is "T:\My Directory\Subdirectory\file\My file.doc",

I want to extract both parts, "T:\My Directory\Subdirectory\file\" and "file.doc" and put them in two different database fields

I don't know too much about string manipulation in ASP.

Thanks,

 

[tsdragon]

Try the inStrRev function. It will find the LAST occurrence of a string within a string:

InStrRev(string1, string2[, start[, compare]])

Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.

 

[Sheco]

If you are using VBScript for your ASP then the functions you need are InStr() or, even better, InStrRev() to find the position of the final slash... Left() to pull everything up to that positon and Mid() to pull everything from that position to the end... or you could just use Mid() for both.

 

[Sheco]

Tracy beat me to it.

 

[DotNetGnat]

You are wanting, InStrRev(),Left(), Right() functions...

example:
blah=Right(strpath,InStrRev(strpath,"\") ->gives you file.doc

play with those functions...

-DNG

 

[DotNetGnat]

Hmm..very slow today...

-DNG

 

[FesterSXS]

InStrRev() seems like the function you want

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[IS300]

All the suggestions were helpful.

Thanks a bunch!