Repalce double quote with double double quote

Question

i need to replace " with "" in full xml string.

i have this:

Dim mioxml As String = "< xml version = "1.0" encoding="UTF-8"> < orderid > Range < /orderid>< operation >RangeA2< /operation>< /order>"

mioxml = mioxml.Replace(""","""")

But on the firt line i have an error (Expected end of instruction)

So i think the problem is on the Dim of mioxml.

Thank you

score 0 · Answer 1 · answered Jun 23 '19 at 19:53

0

You are able to use XML literals in Visual Studios, take a look at the following example:

Dim mioxml As XDocument = New XDocument(
                              New XDeclaration("1.0", "utf-8", "yes"), 
                              <order>
                                <orderid>Range</orderid>
                                <operation>RangeA2</operation>
                              </order>)
Console.WriteLine(mioxml.ToString())

This allows you to write XML elements without having to worry about escaping the double-quotes.

answered Jun 23 '19 at 19:53

David

5,877
3
23
40

I cannot change the string. The string it is like i have. I have only to change the double quote with double double quote without changing the string. i have a lot of that string. – riccio99 Jun 23 '19 at 20:35
@riccio99 Then you will need to escape the double quote. In VB.NET that is done by having two sequential double quotes. E.g. `Dim foo As String = "Hello ""world"" this is escaped."` – David Jun 24 '19 at 03:22

score 0 · Answer 2 · edited Jun 25 '19 at 00:59

Thank you David, this is what I have done as per your suggestion.

Dim mioxml As XDocument =
<?xml version="1.0" encoding="UTF-8"?>
<orders xmlns:xsi="http//www.w3.org/2001/XMLSchema-instance">
    <order>
      <orderid>Range</orderid>
      <operation>RangeA2</operation>
    </order>
</orders>

Dim mioxml2 = mioxml.ToString
mioxml2 = mioxml2.Replace("""", """""")
MsgBox(mioxml2.ToString)

Repalce double quote with double double quote

2 Answers2