parsing XML with ampersand

by

Ideally the XML is escaped properly prior to your code consuming it. If this is beyond your control you could write a regex. Do not use the String.Replace method unless you’re absolutely sure the values do not contain other escaped items.

For example, "wow&".Replace("&", "&") results in wow& which is clearly undesirable.

Regex.Replace can give you more control to avoid this scenario, and can be written to only match “&” symbols that are not part of other characters, such as <, something like:

string result = Regex.Replace(test, "&(?!(amp|apos|quot|lt|gt);)", "&");

The above works, but admittedly it doesn’t cover the variety of other characters that start with an ampersand, such as   and the list can grow.

A more flexible approach would be to decode the content of the value attribute, then re-encode it. If you have value="&wow&" the decode process would return "&wow&" then re-encoding it would return "&wow&", which is desirable. To pull this off you could use this:

string result = Regex.Replace(test, @"value=\""(.*?)\""", m => "value=\"" +
    HttpUtility.HtmlEncode(HttpUtility.HtmlDecode(m.Groups[1].Value)) +
    "\"");
var doc = XElement.Parse(result);

Bear in mind that the above regex only targets the contents of the value attribute. If there are other areas in the XML structure that suffer from the same issue then it can be tweaked to match them and replace their content in a similar fashion.

EDIT: updated solution that should handle content between tags as well as anything between double quotes. Be sure to test this thoroughly. Attempting to manipulate XML/HTML tags with regex is not favorable as it can be error prone and over-complicated. Your case is somewhat special since you need to sanitize it first in order to make use of it.

string pattern = "(?<start>>)(?<content>.+?(?<!>))(?<end><)|(?<start>\")(?<content>.+?)(?<end>\")";
string result = Regex.Replace(test, pattern, m =>
            m.Groups["start"].Value +
            HttpUtility.HtmlEncode(HttpUtility.HtmlDecode(m.Groups["content"].Value)) +
            m.Groups["end"].Value);
var doc = XElement.Parse(result);

More Related Contents:

  1. Get the XPath to an XElement?
  2. How do I read and parse an XML file in C#?
  3. Using Xpath With Default Namespace in C#
  4. XDocument or XmlDocument
  5. Recursion, parsing xml file with attributes into treeview c#
  6. Using StringWriter for XML Serialization
  7. How to Read XML in .NET?
  8. XML Serialization and Inherited Types
  9. DataContract XML serialization and XML attributes
  10. Converting XDocument to XmlDocument and vice versa
  11. HTTP post XML data in C#
  12. Reading data from XML [duplicate]
  13. How do I convert an ISO8601 TimeSpan to a C# TimeSpan?
  14. Getting attribute value of an XML Document using C#
  15. XPATHS and Default Namespaces
  16. Encoding space character in XML name
  17. Error: “The node to be inserted is from a different document context”
  18. using XmlArrayItem attribute without XmlArray on Serializable C# class
  19. How to load XML from URL on XmlDocument()
  20. Getting specified Node values from XML document
  21. How to use XPath function in a XPathExpression instance programatically?
  22. Deserialize object property with StringReader vs XmlNodeReader
  23. Use the XmlInclude or SoapInclude attribute to specify types that are not known statically
  24. How can I get started making a C# RSS Reader?
  25. Writing XML attributes and namespace declarations in a specific order
  26. Read nodes of a xml file in C#
  27. How do I return XML from a Stored Procedure?
  28. How to add xmlnamespace to a xmldocument
  29. Creating a specific XML document using namespaces in C#
  30. How to convert JSON to XML or XML to JSON in C#?

Leave a Comment