Public/PublicFolder/Get-InvalidPublicFolderCharacterReport.ps1

function Get-InvalidPublicFolderCharacterReport {
    <#
    .SYNOPSIS
    Export Report of Public Folders with Invalid Characters
 
    .DESCRIPTION
    Export Report of Public Folders with Invalid Characters
 
    .PARAMETER ExcludedWord
    Don't look for this word in search for invalid characters
 
    .EXAMPLE
    Get-InvalidPublicFolderCharacterReport | Export-Csv .\PFcharReport.csv -notypeinformation -Encoding UTF8
 
    .NOTES
    General notes
    #>



    [CmdletBinding()]
    param (

    )

    $PFDBList = Get-PublicFolderDatabase
    $BadNamePFList = New-Object System.Collections.Generic.List[PSObject]
    ForEach ($PFDB in $PFDBList)    {
        Write-Host "INFO: Checking against... $($PFDB.Server)"
        $FolderList = Get-PublicFolderStatistics -ResultSize Unlimited -Server $PFDB.Server
        foreach ($Folder in $FolderList) {
            if ($Folder.Name -like '*\*' -or
                $Folder.Name -like "*/*" -or
                $Folder.Name -like '*<*' -or
                $Folder.Name -like '*>*' -or
                $Folder.Name -like '*–*' -or
                $Folder.Name -like '*_-*' -or
                $Folder.Name -like ' *' -or
                $Folder.Name -like '* ') {
                Write-Host "FOUND... $($Folder.Name)"
                $BadNamePFList.Add($Folder)
            }
        }
    }
    Write-Host "Number of PFs with Offending Characters: $($BadNamePFList.count)"
    foreach ($BadNamePF in $BadNamePFList) {
        $OffendingChar = New-Object System.Collections.Generic.List[string]
        if ($BadNamePF.Name -like "*\*") {
            $OffendingChar.Add('\')
        }
        if ($BadNamePF.Name -like "*/*") {
            $OffendingChar.Add('/')
        }
        if ($BadNamePF.Name -like "*<*") {
            $OffendingChar.Add('<')
        }
        if ($BadNamePF.Name -like "*>*") {
            $OffendingChar.Add('>')
        }
        if ($BadNamePF.Name -like "*_-*") {
            $OffendingChar.Add('_-')
        }
        if ($BadNamePF.Name -match '\u2013') {
            $OffendingChar.Add('EnDash')
        }
        if ($BadNamePF.Name -like " *") {
            $OffendingChar.Add('Lead-Whitespace')
        }
        if ($BadNamePF.Name -like "* ") {
            $OffendingChar.Add('Trail-Whitespace')
        }

        $NewFolder = $BadNamePF.Name.Replace('\', '-')
        $NewFolder = $NewFolder.Replace('/', '-')
        $NewFolder = $NewFolder.Replace('<', '')
        $NewFolder = $NewFolder.Replace('>', '')
        $NewFolder = $NewFolder.Replace('_-', '-')
        $NewFolder = $NewFolder -replace '\u2013|\u2014', '-'

        Write-Host "Old Folder Name:`t $($BadNamePF.Name)" -ForegroundColor "Cyan"
        Write-Host "New Folder Name:`t$NewFolder" -ForegroundColor "Green"
        Write-Host ""
        Write-Host ""


        $CorrectedPF = New-Object -TypeName PSObject -Property @{
            FolderPath    = $BadNamePF.FolderPath
            OldFolder     = $BadNamePF.Name
            NewFolder     = $NewFolder
            OffendingChar = $OffendingChar
            Database      = $BadNamePF.DatabaseName
            Identity      = $BadNamePF.Identity
            CreationTime  = $BadNamePF.CreationTime
        }
        $CorrectedPF | Select FolderPath, OldFolder, NewFolder, OffendingChar, Database, Identity, CreationTime
    }
}