XML parsing error with double quote character.

[Terrence Chan]

I have try the below and the problem is my xmlstring is something like
"<employee name="Joh"n">

strXML = Replace(strXML, "&", "&amp;")
strXML = Replace(strXML, "<", "&lt;")
strXML = Replace(strXML, ">", "&gt;")
strXML = Replace(strXML, "'", "&apos;")
strXML = Replace(strXML, """", "&quot;")

after this it will be like this
<employee name=&quot;Joh&quot;n&quot;>

How to slove the double quote in xmlstring?

Thanks.

 

[Jay B. Harlow [MVP - Outlook]]

Terrence,

How to slove the double quote in xmlstring?

I would use a System.Xml.XmlTextWriter to create well formed XML!

You can use XmlTextWriter with a StringWriter to write the XML to a string.

Something like:

Dim buffer As New System.IO.StringWriter
Dim writer As New System.Xml.XmlTextWriter(buffer)

writer.WriteStartElement("employee")
writer.WriteAttributeString("name", "Joh""n")
writer.WriteEndElement()

writer.Close()
buffer.Close()

Dim xmlstring As String = buffer.ToString()
Debug.WriteLine(xmlstring, "xmlString")

Using XmlTextWriter will also ensure that any extended characters are
properly encoded, based on the System.Text.Encoding object passed to the
constructor. Note if you use a StringWriter, as I did above, the encoding is
going to be UTF-16, it can be changed with effort, post if want a sample.

Hope this helps
Jay

 

[Terrence Chan]

Hi Jay,
It is working well!
Thanks.
Terrence