«

I'm trying to remove the word 'AND' (apostrophes included) from a string but
can't seem to get the correct expression.

I've got:

Dim regRemove As New System.Text.RegularExpressions.Regex("\b'AND'\b")
Dim strInput As String = "One 'AND' Two"
Response.Write(regRemove.Replace(strInput, ""))

But it doesn't work. Do the apostrophes in my regex need to be escaped?
I've tried \' and '' but to no avail.

Any ideas?

Thanks

"Dan" <> wrote in message news:%...
> I'm trying to remove the word 'AND' (apostrophes included) from a string but
> can't seem to get the correct expression.
>
> I've got:
>
> Dim regRemove As New System.Text.RegularExpressions.Regex("\b'AND'\b")
> Dim strInput As String = "One 'AND' Two"
> Response.Write(regRemove.Replace(strInput, ""))
>
> But it doesn't work. Do the apostrophes in my regex need to be escaped?
> I've tried \' and '' but to no avail.
>
> Any ideas?
>
> Thanks
>
>

The quote is OK, the problem is with the \b: it matches a boundary
between alphanumeric and non-alphanumeric. Space and ' are both
non-alphenumeric, so there is no boundary!

You could try \B: match on non-boundary.

Hans Kesting

Why not just do this?

NewString = Replace(inputstring, "AND", "")

/Lars



"Dan" <> skrev i meddelandet
news:%...
> I'm trying to remove the word 'AND' (apostrophes included) from a string
but
> can't seem to get the correct expression.
>
> I've got:
>
> Dim regRemove As New System.Text.RegularExpressions.Regex("\b'AND'\b")
> Dim strInput As String = "One 'AND' Two"
> Response.Write(regRemove.Replace(strInput, ""))
>
> But it doesn't work. Do the apostrophes in my regex need to be escaped?
> I've tried \' and '' but to no avail.
>
> Any ideas?
>
> Thanks
>
>

Thanks, but that won't cope with something like:

SUN AND SAND

"Lars Netzel" <> wrote in message
news:O7x$...
> Why not just do this?
>
> NewString = Replace(inputstring, "AND", "")
>
> /Lars
>
>
>
> "Dan" <> skrev i meddelandet
> news:%...
> > I'm trying to remove the word 'AND' (apostrophes included) from a string
> but
> > can't seem to get the correct expression.
> >
> > I've got:
> >
> > Dim regRemove As New System.Text.RegularExpressions.Regex("\b'AND'\b")
> > Dim strInput As String = "One 'AND' Two"
> > Response.Write(regRemove.Replace(strInput, ""))
> >
> > But it doesn't work. Do the apostrophes in my regex need to be escaped?
> > I've tried \' and '' but to no avail.
> >
> > Any ideas?
> >
> > Thanks
> >
> >
>
>

Great, thanks! This did the trick.

"Hans Kesting" <> wrote in message
news:...
>
> "Dan" <> wrote in message
news:%...
> > I'm trying to remove the word 'AND' (apostrophes included) from a string
but
> > can't seem to get the correct expression.
> >
> > I've got:
> >
> > Dim regRemove As New System.Text.RegularExpressions.Regex("\b'AND'\b")
> > Dim strInput As String = "One 'AND' Two"
> > Response.Write(regRemove.Replace(strInput, ""))
> >
> > But it doesn't work. Do the apostrophes in my regex need to be escaped?
> > I've tried \' and '' but to no avail.
> >
> > Any ideas?
> >
> > Thanks
> >
> >
>
> The quote is OK, the problem is with the \b: it matches a boundary
> between alphanumeric and non-alphanumeric. Space and ' are both
> non-alphenumeric, so there is no boundary!
>
> You could try \B: match on non-boundary.
>
> Hans Kesting
>
>
>

true!

Can you use a comma instead of AND to separate the words in the string and
just split everything into an array?

/Lars

"Dan" <> skrev i meddelandet
news:%...
> Thanks, but that won't cope with something like:
>
> SUN AND SAND
>
> "Lars Netzel" <> wrote in message
> news:O7x$...
> > Why not just do this?
> >
> > NewString = Replace(inputstring, "AND", "")
> >
> > /Lars
> >
> >
> >
> > "Dan" <> skrev i meddelandet
> > news:%...
> > > I'm trying to remove the word 'AND' (apostrophes included) from a
string
> > but
> > > can't seem to get the correct expression.
> > >
> > > I've got:
> > >
> > > Dim regRemove As New System.Text.RegularExpressions.Regex("\b'AND'\b")
> > > Dim strInput As String = "One 'AND' Two"
> > > Response.Write(regRemove.Replace(strInput, ""))
> > >
> > > But it doesn't work. Do the apostrophes in my regex need to be
escaped?
> > > I've tried \' and '' but to no avail.
> > >
> > > Any ideas?
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>