Function convert(mot As String, ch1 As String, ch2 As String) As String For i = 1 To Len(mot) For j = 1 To Len(ch1) If Mid(mot, i, 1) = Mid(ch1, j, 1) Then Mid(mot, i, 1) = Mid(ch2, j, 1) End If Next j Next i convert = mot End Function
text2 = convert(Trim(Text1), "ÀÁÂÃÄÅàáâãäåÒÓÔÕÖØòóôõöøÈÉÊËèéêëÇçÌÍÎÏìíîïÙÚÛÜùúûüÿÑñ", "aaaaaaaaaaaaooooooooooooeeeeeeeecciiiiiiiiuuuuuuuuynn")
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionFunction convert(mot As String, ch1 As String, ch2 As String) As String Dim i As Integer, j As Integer Dim L As Integer: L = Len(ch1) convert = mot Dim ch As String For i = 1 To Len(convert) ch = Mid(convert, i, 1) For j = 1 To L If 0 = StrComp(ch, Mid(ch1, j, 1)) Then Mid(convert, i, 1) = Mid(ch2, j, 1) Exit For End If Next j Next i End Function