1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| Public Function fSupprimeCars(ByVal chaine As String) As String
Dim Position As Integer 'Remplace tous les carractères spéciaux
For Position = Len(chaine) To 1 Step -1
Select Case Mid(chaine, Position, 1)
Case "à", "á", "â", "ã", "ä", "å", "Ä"
chaine = Left(chaine, Position - 1) & "a" & Mid(chaine, Position + 1)
Case "ç"
chaine = Left(chaine, Position - 1) & "c" & Mid(chaine, Position + 1)
Case "é", "è", "ë", "ê"
chaine = Left(chaine, Position - 1) & "e" & Mid(chaine, Position + 1)
Case "ì", "í", "î", "ï"
chaine = Left(chaine, Position - 1) & "i" & Mid(chaine, Position + 1)
Case "ñ"
chaine = Left(chaine, Position - 1) & "n" & Mid(chaine, Position + 1)
Case "ò", "ó", "ô", "õ", "ö"
chaine = Left(chaine, Position - 1) & "o" & Mid(chaine, Position + 1)
Case "ù", "ú", "û", "ü"
chaine = Left(chaine, Position - 1) & "u" & Mid(chaine, Position + 1)
Case "ý", "ÿ"
chaine = Left(chaine, Position - 1) & "y" & Mid(chaine, Position + 1)
Case "&", "'", """", "~", "{", "[", "-", "|", "`", "_", "\", "^", "@", ")", "(", "]", "=", "+", "}", "^", _
"$", "£", "¤", "*", "µ", "ù", "%", ",", "?", ";", ".", ":", "/", "!", "§"
chaine = Left(chaine, Position - 1) & "" & Mid(chaine, Position + 1)
End Select
Next Position
fSupprimeCars = chaine
End Function |
Partager