Advertisement
Guest User

Untitled

a guest
Feb 7th, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. Function entferne_sonstige_zeichen(description)
  2. 'Entfernt alle Zeichen außer Kommata, Buchstaben, Ziffern, Querstriche (/) und Bindestriche (-)
  3. entferne_sonstige_zeichen = description
  4.  
  5. Dim oRegExp As RegExp
  6. Set oRegExp = New RegExp
  7. With oRegExp
  8. .IgnoreCase = False
  9. .Global = True
  10. .MultiLine = True
  11. .Pattern = "[^A-Za-z\d,/-]"
  12. End With
  13.  
  14. Dim ReplacePattern As String
  15. ReplacePattern = ""
  16.  
  17. description = oRegExp(ReplacePattern)
  18.  
  19. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement