1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Function TraiteTexte(Txt As String) As String
Dim Pattern As String, i As Long, Traite As String
Traite = Txt
Pattern = ""
For i = 1 To Len(Txt)
If Not IsNumeric(Mid(Txt, i, 1)) And Mid(Txt, i, 1) <> "#" And Mid(Txt, i, 1) <> ";" Then
Pattern = ""
ElseIf (IsNumeric(Mid(Txt, i, 1)) Or Mid(Txt, i, 1) = "#") And Pattern = "" Then
Pattern = Mid(Txt, i, 1)
ElseIf Pattern <> "" Then
Pattern = Pattern & Mid(Txt, i, 1)
End If
If Pattern Like "#*;[#]" Or Pattern Like "[#]#*;[#]" Then
Traite = Replace(Traite, Pattern, "")
Pattern = ""
End If
Next i
TraiteTexte = Traite
End Function |
Partager