Get file path

[arcticpup]

Hi,

I'm ertrieving a value from SQL and need help with getting the file path (The SQL string contains the full path and filename, so I want to remove just the name)

the object of this is to create a shortcut to the file directory on the users desktop. Shortcut creates fine, SQL value retrieves fine, just need help with removing the file name?

Cheers!

[Inverted]

Use the string functions to split the string left from the last "\" character (I guess)

[arcticpup]

Use the string functions to split the string left from the last "\" character (I guess)

Thank you, I guessed it would be the string functions, but which ones given that the file name is not a set length?

[logmein]

i suggest using _PathSplit($szPath, ByRef $szDrive, ByRef $szDir, ByRef $szFName, ByRef $szExt) , the AutoIT help file may be useful :-)