Guest User

Untitled

a guest
Jul 18th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. Function CleanUp (input)
  2. Dim objRegExp, outputStr
  3. Set objRegExp = New Regexp
  4.  
  5. objRegExp.IgnoreCase = True
  6. objRegExp.Global = True
  7. objRegExp.Pattern = "((?![a-zA-Z0-9]).)+"
  8. outputStr = objRegExp.Replace(input, "-")
  9.  
  10. objRegExp.Pattern = "-+"
  11. outputStr = objRegExp.Replace(outputStr, "-")
  12.  
  13. CleanUp = outputStr
  14. End Function
  15.  
  16. MsgBox (CleanUp("Test"))
Add Comment
Please, Sign In to add comment