Illegal Characters Scanning Utility

Posted on 2013-10-15
Medium Priority
Last Modified: 2013-10-15
We are preparing to upload a lot of company data to SharePoint online.

We know there are characters which are not permitted in folders and file names such as the ampersand (&). Is there a utility which we can run on the local data which will provide output of all the folders / files which will not be compliant and in an ideal world make changes?

If you try to upload folders / files which have illegal characters to SharePoint online, does it simply stop you or produce a report at the end?
Question by:Hypervizor
LVL 46

Accepted Solution

Vasil Michev (MVP) earned 2000 total points
ID: 39573539
The list of characters is not that big, if you remove the ones not allowed on NTFS filesystem anyway:


To list such files, you can use PowerShell:

Get-ChildItem C:\ -Force -Recurse | ? {$_.Name -match "&|\#|~|%|\{|}|\+"}

Open in new window

A quick way to list the names, replacing any invalid characters with space:

Get-ChildItem C:\ -Force -Recurse | ? {$_.Name -match "&|\#|~|%|\{|}|\+"} | foreach { $name = $_.Name -replace '&|\#|~|%|\{|}|\+',' '; echo $Name}

Open in new window


Author Comment

ID: 39573551
Excellent, thanks.

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Office 365 has multiple features and services which are specially designed to help businesses to reduce their dependence on on-premises IT resources. It also offers great flexibility and enhanced security. But like any other data, Office 365 mailbo…
Migrating Exchange data from one Exchange Server to another server is complicated. Though Exchange administrators can try manual methods to migrate their data from one version of Exchange to another, these manual methods are not that reliable. That…
how to add IIS SMTP to handle application/Scanner relays into office 365.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question