Hello group,

I think I understand how to remove whitespace in all Exchange 2007 public folder alias;

get-publicfolder -identity "\" -Recurse -ResultSize Unlimited | Foreach { Set-publicfolder -Identity $_.Identity -Name $_.Name.Trim() }

My question is how do I remove both whitespace and another invalid character such as a comma ,

For example if my public folder alias was;

glenn, tom 2001

and i wanted it to be;

glenntom2001

Thanks for any help.

Joe

I need a command to remove all the invalid characters in the alias for Exchange 2007.  I have several thousand aliases that are similiar to   Smith, Joe D.  There are multiple invalid characters in them.  Any help would be appreciated.  Thanks,

Eric C.

I forgot to add that these are all contacts. 

Thanks,

Eric C.

That command work beautifully!!!  Thanks, Shay

Eric C.

What is the powershell comman for identifyting white space on each of the mailbox databases and how to I port the info to a csv file.

When I try to run a modified version of this command, (and the original command, for that matter):

Get-MailContact -ResultSize Unlimited | Foreach {$_.alias = $_.alias -replace ‘\.’; $_} | Set-MailContact -whatif

I receive the following errors (one for each MailContact, all have similiar verbage to below):

Exception setting "Alias": ""PGR-7075996570(SDL-Eureka)" is not valid for Alias . Valid values are: Strings formed with characters from a to z (uppercase or lo wercase), digits from 0 to 9, !, #, $, %, &, ', *, +, -, /, =, ?, ^, _, `, {, | , } or ~. One or more periods may be embedded in an alias, but each one of them should be preceded and followed by at least one of the other characters. Unico de characters from U+00A1 to U+00FF are also valid in an alias, but they will b e mapped to a best-fit US-ASCII string in the email address which is generated from such an alias." At line:1 char:53
 
+ Get-MailContact -ResultSize Unlimited | Foreach {$_.a <<<< lias = $_.alias -r eplace `\.'; $_} | Set-MailContact -whatif Set-MailContact : ".PGR-7075996570(SDL-Eureka)" is not valid for Alias. Valid v alues are: Strings formed with characters from a to z (uppercase or lowercase), digits from 0 to 9, !, #, $, %, &, ', *, +, -, /, =, ?, ^, _, `, {, |, } or ~. One or more periods may be embedded in an alias, but each one of them should b e preceded and followed by at least one of the other characters. Unicode charac ters from U+00A1 to U+00FF are also valid in an alias, but they will be mapped to a best-fit US-ASCII string in the email address which is generated from such an alias. At line:1 char:106
 
+ Get-MailContact -ResultSize Unlimited | Foreach {$_.alias = $_.alias -replace `\.'; $_} | Set-MailContact <<<< -whatif WARNING: Object anyone.anywhere.com/SDL-GLB/Contacts/.PGR-7075996570 (SDL-Eureka) has been corrupted and it is in an inconsistent state. The following validation errors have occurred:
WARNING: ".PGR-7075996570(SDL-Eureka)" is not valid for Alias. Valid values are: Strings formed with characters from a to z (uppercase or lowercase), digits from 0 to 9, !, #, $, %, &, ', *, +, -, /, =, ?, ^, _, `, {, |, } or ~. One or more periods may be embedded in an alias, but each one of them should be preceded and followed by at least one of the other characters. Unicode characters from U+00A1 to U+00FF are also valid in an alias, but they will be mapped to a best-fit US-ASCII string in the email address which is generated from such an alias.

I would think that the command should still work for me, as I'm only removing qualifying characters from the script.