Category: ASP.NET

03 Dec 2015 21:14

Joined:	23/06/2011
Level:	Gold
Points:	510

Points:	5

How to escape Special character in XML

Hi All,

I have XML data in string and tried to convert that string in to XML using
XmlDocument xl=new XmlDocument();
xl.LoadXml(mystring);

It was not parsing because my string has special character in xml element like below.

<ROOT>
<SUB>
<DATA>name < lastname</DATA>
<DATA>Myname > lastname</DATA>
<DATA>some special character in between text</DATA>
......
.....
</ROOT>
</SUB>
There were many <DATA> in my xml. It was generating dynamically.

I have tried to change < < > > but it was replacing other XML tags.

How to escape above special character without change other XML tags ?

Please help me to resolve this

#763413

03 Dec 2015 21:42

Joined:	06/04/2012
Level:	Gold
Points:	4137

Points:	3

Hello Rajan,

You can use this code :

VB :

Private Function ReplaceXmlText(ByVal strXmlText As String) As String
Dim strXml As String
strXml = Replace(strXmlText, "&", "&")
strXml = Replace(strXml, "'", "'")
strXml = Replace(strXml, """", """)
strXml = Replace(strXml, ">", ">")
strXml = Replace(strXml, "<", "<")
ReplaceXmlText = strXml
End Function

Example :

<DATA>" + ReplaceXmlText(">") + "</DATA>

C# :

private string ReplaceXmlText(string strXmlText)
{
string strXml = null;
strXml = Strings.Replace(strXmlText, "&", "&");
strXml = Strings.Replace(strXml, "'", "'");
strXml = Strings.Replace(strXml, "\"", """);
strXml = Strings.Replace(strXml, ">", ">");
strXml = Strings.Replace(strXml, "<", "<");
return strXml;
}

Example :
<DATA>" + ReplaceXmlText("<") + "</DATA>

Hope this will be helpful for you.

Regards,
Nirav Lalan
DNS Gold Member
"Failure is the path of least persistence"

#763414

03 Dec 2015 21:51

Joined:	05/06/2009
Level:	Gold
Points:	10245

Points:	2

you can use the following for escape for you xml

< is replaced with <
> is replaced with >

By Nathan
Direction is important than speed

#763530

11 Dec 2015 22:01

Joined:	13/06/2007
Level:	Gold
Points:	21314

Points:	3

Have you tried to use .Save() method of XMLDocument class, after using 'loadXml()' method
but before that be sure to keep at least one root element
see below snippet
string szData = "<root><data>Appple<data><data>Mango<data></root>";
XmlDocument xl=new XmlDocument();
xl.LoadXml(mystring);
xl.Save("D:\\test.xml");

hope it helps

Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

How to escape Special character in XML

Email subscription

About dotnetspider.com

Quick Links

General

Services