Sorry for the lack of blogging lately, it’s not that I haven’t had PLENTY of material – I just frankly haven’t had time to post anything.
However, I thought I’d share a recent function I threw together – if for no other reason than to make sure I don’t forget how I did this…
I’m currently working on a big migration from a legacy HTML website to SharePoint 2010 FIS-E. During this migration, I’ve used PowerShell a LOT to automate tasks and cleanup things. An example of something I needed to clean up is links used for top navigation. We are using a 3rd party web part for our top navigation – it is list driven.
The links in the list all work, but some were entered as lowercase, some camel-case, some with no rhyme or reason at all. I wanted consistency, and I’m sure my client would too…
I wrote a simple helper function to walk through the list and convert every item in a specified column to lowercase. Pretty easy, not much to it… Also, this could easily be modified to do other things like convert to uppercase. I just wanted lowercase. Here it is!
function Convert-SPListItemStringsToLowercase { Param( [string]$WebUrl, [string]$ListName, [string]$ColumnName ) $web = Get-SPWeb $WebUrl $list = $web.Lists[$ListName] $items = $list.Items foreach ($item in $items){ $item[$ColumnName] = $item[$ColumnName].toLower() $item.Update() $list.Update() }#end Foreach $web.Update() $web.Dispose() }#end function