Advanced string manipulation question??

[CJAI]

Need some help with converting this string to a format that I can use (in the middle of creating a document management system).

string:
W:\Documentation Team Shares\IT\Draft\IT Procedure Manual.doc

**need to use string manipulation to pull the above BOLDED folder (IT) - since this folder will be different for different documents

thanks for your help!!!

 

[ChrisHirst]

use split() in a function

function GetFolder(PathString)
dim PathArray
PathArray = Split(PathString,"\")
GetFolder = PathArray(2)
end function

Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.