How to format a rowfilter which includes quote characters...

[Guest]

How canI format the text in a rowfilter expression for a DataView object
which contains a quote mark...is there a special escape character? or what?

For example, "Album = 'One's too many'"

Thanks

 

[Guest]

Hi DK,

You can use double quotes to escape single quote.

Dataview.RowFilter = "Album = 'One''s too many'â€

HTH

Elton Wang
(e-mail address removed)

 

[Cor Ligthert]

What is in VBNet two quotes.

You can use double quotes to escape single quote.

Dataview.RowFilter = "Album = 'One''s too many'"

What is in VBNet two double quotes in the code.

 

[Elton W]

Hi Cor,

I don't understand your question.

If you mean following:

Dim str As String = "It's 2"" width."

The str is It's 2" width.

Elton

 

[Cor Ligthert]

Elton,

Just wrong English.

A single quote has to be written in VBNet as 2 double quotes.

Thanks for pointing me on that.

Cor