I have a Xml node having a value encoded such as the ampersand sign. When I use the XmlNodeList approach with the XmlNode object, I end up with the exact extraction. Thus, the value "Test" is now "T & a m p ; est". Is there something that can be done here with the XmlNodeList and XmlNode object instead of having to add some parsing at the end at the value level to fix that?
For Each loXmlNode In loXml.oXmlNodeList
loXmlNode2 = loXmlNode.SelectSingleNode("Entity")
loXmlNode2 = loXmlNode.SelectSingleNode("FirstName")
lcFirstName = Trim(loXmlNode2.InnerXml)