February 26th, 2005 by obts
Subject: files names with & in them
Date: Fri, 18 Feb 2005 05:53:06 -0800
I’m trying to upload 18 gig of pictures, literally thousands of pictures from CD-ROMs into multiple picture libraries. Many of these pictures, mostly clipart type things have “&” in the file names and it won’t let me upload them. This is a real pain in the backside…
especially as the book that people use to browse has the “&” in the name and therefore when they go to look for it, that’s’ what they will expect. I don’t understand why this character can’t be used? Surely Sharepoint should be able to escape it so it doesn’t cause SQL/Filesystem problems?
This is one of the main parts of our Sharepoint project and to be honest, I’m not sure it’s worth it anymore if I really can’t have this character in my file names… anyone have any clever ideas on how to get around this?
Subject: RE: files names with & in them
Date: Fri, 18 Feb 2005 09:15:11 -0800
The problem is that you’re no longer retrieving files from DOS or NTFS, you’re pulling them across HTTP and standards for URLs apply.
The specification for URLs (RFC 1738, Dec. ’94) poses a problem, in that it limits the use of allowed characters in URLs to only a limited subset of the US-ASCII character set:
“…Only alphanumerics [0-9a-zA-Z], the special characters $-_.+!*'(), and reserved characters used for their reserved purposes may be used unencoded within a URL.”
?&= are reserved characters and their reserved purposes are to delimit parameters, so they aren’t allowed in file names.
My suggestion would be to bring the files off CD onto an interim location where you can do a global search and replace to translate from “&” to “And” and then move your documents into SP. Windows Commander
( http://www.ghisler.com/ ) has a nice multi-rename tool, it’s folder-by-folder but will remember your last settings each time you press Ctrl-M to run it. I’m sure there are others.