February 2005
« Jan   Mar »

files names with & in them

February 26th, 2005 by

From: <>

Subject: files names with &  in them

Date: Fri, 18 Feb 2005 05:53:06 -0800

Newsgroups: microsoft.public.sharepoint.portalserver




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?






From: <>

Subject: RE: files names with &  in them

Date: Fri, 18 Feb 2005 09:15:11 -0800

Newsgroups: microsoft.public.sharepoint.portalserver


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.


From :


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

( ) 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.


Take care,



Posted in SPPS03_Tips | No Comments »

Comments are closed.