Click to See Complete Forum and Search --> : Excluding AND/OR using regular expression


nraghuramireddy
04-28-2010, 05:39 AM
Hi
I wrote one function that appends * for each word. The function looks like
Function GetQuery( KW )
Dim RExp
Set RExp = New RegExp
RExp.IgnoreCase = True
RExp.Global = true
RExp.Pattern = "[ *,]+"
KW = RExp.Replace(KW, "* ")
Set RExp=nothing
End Function

If give input like web AND developer then out put of this function would be web* AND* developer*.
But i need the regular expression that excludes appending * for AND/OR keywords.

Please any one help me out on this.

With best regards
Raghuram