arcticpup Posted May 19, 2009 Share Posted May 19, 2009 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! Link to comment Share on other sites More sharing options...
Inverted Posted May 19, 2009 Share Posted May 19, 2009 Use the string functions to split the string left from the last "\" character (I guess) Link to comment Share on other sites More sharing options...
arcticpup Posted May 19, 2009 Author Share Posted May 19, 2009 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? Link to comment Share on other sites More sharing options...
logmein Posted May 19, 2009 Share Posted May 19, 2009 i suggest using _PathSplit($szPath, ByRef $szDrive, ByRef $szDir, ByRef $szFName, ByRef $szExt) , the AutoIT help file may be useful :-) [font=arial, helvetica, sans-serif][s]Total USB Security 3.0 Beta[/s] | [s]Malware Kill[/s] | Malware Scanner | Screen Hider | Locker | Matrix Generator[s]AUTO-SYNC 1.0 | MD5 Hash Generator | URL Checker | Tube Take [/s]| Random Text[/font] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now