[thelist] regex help

Brian Cummiskey Brian at hondaswap.com
Fri Nov 16 13:30:37 CST 2007


Hi guys,

I'm looking for a regex for some textareas.  Basically, anything goes, 
so I can't strip out everything.
On the contrary, I'm ALLOWING things instead.

Here's what i've come up with so far:


Function cleanup(str)
    str =Trim(str)
    Dim regEx
    Set regEx = New RegExp

    ' find ALL matching substrings, instead of just the first instance.
    regEx.Global = true
    regEx.Pattern = "[^0-9a-zA-Z\s-.]"

    'replace the junk with ''
    output = regEx.Replace(str, "")

    cleanup = output

End function


This gets me everything i need except single quotes and double quotes, 
but they need to be escaped.

any suggestions?





More information about the thelist mailing list