SharePoint 2010 - Formulas

Some resources for SharePoint formulas:

• http://office.microsoft.com/en-us/windows-sharepoint-services-help/CH001171117.aspx
• http://office.microsoft.com/en-us/support/results.aspx?ctags=CH010372694
• http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx

 Cheat Sheet I found:

Powershell - File Renaming

Here is a quick powershell script to tidy files that are not properly formatted for the web.

Get-ChildItem C:\Temp\rename\* -Recurse | Rename-Item -NewName {$_.name -creplace '[^A-Za-z1234567890.]','_' }
Get-ChildItem C:\Temp\rename\* -Recurse | Rename-Item -NewName {$_.name -replace '___','_' }
Get-ChildItem C:\Temp\rename\* -Recurse | Rename-Item -NewName {$_.name -replace '__','_' }