| Author |
 Topic  |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
 Posted - 10 July 2013 : 12:11:35
|
I want to check for the existence of files using FSO, but if the file path and/or name include an apostrophe, the program breaks. Anyone have a suggestion?
Example code:
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 11 July 2013 : 09:18:36
|
| Replacing with an \' or with an '' doesn't work. Any other suggestions? |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 July 2013 : 10:45:19
|
quote:
From the Script Guy's Blog
Incidentally, if you’re using the FileSystemObject (another way to work with files and folders), you don’t have to worry about this; the apostrophe doesn’t seem to bother the FileSystemObject. For example, if you want to know the size of Ken Myer’s Folder, use this code:
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder("C:\Ken Myer’s Folder")
Wscript.Echo "Size: " & objFolder.Size
No escaping or other coding tricks required.
|
MVC .net dev/test site | MVC .net running on Raspberry Pi |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 11 July 2013 : 11:50:13
|
| The code works perfectly on all folders/files except for those containing an apostrophe and/or an ampersand. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 11 July 2013 : 13:34:15
|
this is the code I ran, and it quite happily displays that the file exists
<%
strPath = "c:\temp\"
strFile = "apostroph'e&ersand.txt"
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
If not objFSO.FileExists(strPath&strFile) Then
strErr=strErr & "<li>"&strFile&" does not exist.</li>"
Else
strErr=strErr & "<li>"&strFile&" exists.</li>"
End If
Set objFSO = Nothing
Response.Write strErr
%>
results in
- apostroph'e&ersand.txt exists.
FYI, your code errors on the line objFSO.Close |
MVC .net dev/test site | MVC .net running on Raspberry Pi |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 11 July 2013 : 20:04:38
|
| Found it - wasn't in this routine but in the chkstring function; was resulting in a double apostrophe before checking the file name. Thanks. Now if only I could figure out that javascript mouse-over routine, I'd be through with this and I could rest. |
Edited by - Carefree on 11 July 2013 20:05:52 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 11 August 2015 : 16:22:13
|
| This is very old, but here's an update. I solved the mouseover Javascript routine by replacing apostrophes with the U+2032 symbol (#8242;). They still look like apostrophes (and actually sort properly now whereas the apostrophe didn't), so now the Javascript is happy. |
|
|
| |
Topic |
|
FileSystemObject and Apostrophes
