Match all users that have a phone number with the syntax (123)456-7890 or (123) 456 - 7890
Get-QADUser -sizelimit 0 | where {$_.telephonenumber -match "^\([1-9][0-9]{2}\)\s?[0-9]{3}\s?-\s?[0-9]{4}"} | select -property name, telephonenumber
#Find accounts with phone numbers like (123)456-7890 or (123) 456 - 7890
$AccountTelephone = Get-QADUser -sizelimit 0 | where {$_.telephonenumber -match "^\([1-9][0-9]{2}\)\s?[0-9]{3}\s?-\s?[0-9]{4}"}
ForEach ($user in $AccountTelephone)
{
$newPhoneNum = $user.Telephonenumber
$newPhoneNum = $newPhoneNum -replace "\(",""
$newPhoneNum = $newPhoneNum -replace "\)[\s]?","."
$newPhoneNum = $newPhoneNum -replace "[\s]?\-[\s]?","."
Write-Host "Changeing phone number for user" $user.SamAccountName, "from" $user.Telephonenumber "to " $newPhoneNum
#Set-QADUser $user.DN -phonenumber $newPhoneNum
}
$dom = [ADSI]""
$filter = "(&(objectcategory=person)(objectclass=user))"
$Searcher = New-Object system.directoryservices.directorysearcher($dom)
$Searcher.PageSize = 500
$Searcher.Filter = $filter
$aryUsers = $Searcher.FindAll()
$i = 1
Foreach ($user in $aryUsers)
{
$DE = $user.GetDirectoryEntry()
$sTelephoneNumber = $DE.TelephoneNumber
$sTelephoneNumber = $sTelephoneNumber -replace "\(",""
$sTelephoneNumber = $sTelephoneNumber -replace "\)[\s]*","."
$sTelephoneNumber = $sTelephoneNumber -replace "\-","."
Write-Host "Update modifying phone number attribute [$sTelephoneNumber]"
$DE.TelephoneNumber = $sTelephoneNumber
$DE.psbase.commitchanges()
}