update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,'..','.') where LeaverTempIdentifier like '%..%'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,'&','') where LeaverTempIdentifier like '%&%'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,'"','') where LeaverTempIdentifier like '%"%'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,'É','E') where LeaverTempIdentifier like '%É%'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,'è','e') where LeaverTempIdentifier like '%è%'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,'ñ','n') where LeaverTempIdentifier like '%ñ%'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,'é','e') where LeaverTempIdentifier like '%é%'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,' ','.') where LeaverTempIdentifier like '% %'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,'ç','c') where LeaverTempIdentifier like '%ç%'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,' ','-') where LeaverTempIdentifier like '% %'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,'+','') where LeaverTempIdentifier like '%+%'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,'[','') where LeaverTempIdentifier like '%[%'

update LeaverMappingSelection set LeaverTempIdentifier = REPLACE (LeaverTempIdentifier,']','') where LeaverTempIdentifier like '%]%'


update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,'..','.') where UserPrincipalName like '%..%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,'..','.') where PrimarySmtpAddress like '%..%'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,'&','') where UserPrincipalName like '%&%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,'&','') where PrimarySmtpAddress like '%&%'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,'"','') where UserPrincipalName like '%"%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,'"','') where PrimarySmtpAddress like '%"%'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,'É','E') where UserPrincipalName like '%É%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,'É','E') where PrimarySmtpAddress like '%É%'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,'è','e') where UserPrincipalName like '%è%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,'è','e') where PrimarySmtpAddress like '%è%'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,'ñ','n') where UserPrincipalName like '%ñ%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,'ñ','n') where PrimarySmtpAddress like '%ñ%'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,'é','e') where UserPrincipalName like '%é%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,'é','e') where PrimarySmtpAddress like '%é%'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,' ','.') where UserPrincipalName like '% %'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,' ','.') where PrimarySmtpAddress like '% %'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,'ç','c') where UserPrincipalName like '%ç%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,'ç','c') where PrimarySmtpAddress like '%ç%'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,' ','-') where UserPrincipalName like '% %'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,' ','-') where PrimarySmtpAddress like '% %'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,'+','') where UserPrincipalName like '%+%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,'+','') where PrimarySmtpAddress like '%+%'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,'[','') where UserPrincipalName like '%[%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,'[','') where PrimarySmtpAddress like '%[%'

update Mailboxes set UserPrincipalName = REPLACE (UserPrincipalName,']','') where UserPrincipalName like '%]%'
update Mailboxes set PrimarySmtpAddress = REPLACE (PrimarySmtpAddress,']','') where PrimarySmtpAddress like '%]%'