escape char function

[Guest Cheung]

Do you know any function that change ' (single quote) to '' (2 single quotes) in a string?

[divil]

There aren't escape characters in VB.NET. You can use two double quotes ("") next to each other to have an inline double quote in a string, e.g.

 

strString = "This ""word"" is enclosed in double quotes."

[Guest Cheung]

Any function to do this for me?

 

function input string = It isn't bad

function output string = It isn''t bad

 

Thx!

[divil]

Oh, I misunderstood.

 

Use the Replace() function.

[Guest Perl]

Dim MyString as String = "'Hello My Name Is Simon'"

MyString.replace( "'", Chr(34) )

 

*Should Work* :)

 

Or you could just write it out using Chr(34) but who wants to do that ? :)

[Guest Cheung]

I got it. Thanks !!