A newline (aka line break or end-of-line, EOL) is special character or character sequence that marks the end of a line of text. The exact codes used vary across operating systems: Operating System End-of-Line (EOL) marker Unix LF Mac OS up to version 9 CR Windows, DOS CR+LF You can use 
 for line feed … Read more
I know this isn’t the answer you want – but the XML spec is quite clear and strict. Malformed XML is fatal. If it doesn’t work in a validator, then your code should not even attempt to “fix” it, any more than you’d try and automatically ‘fix’ some program code. From The Anotated XML Specification: … Read more
You really should use a tool that is designed specifically to manipulate XML. But in a pinch, you could use any tool that can do a regex search and replace to do a naive solution that would work with the file as you have it laid out, but might fail with a logically equivalent XML … Read more
The code for creating a dictionary with all the declared namespaces can be made quite simple. This is all that is needed: import xml.etree.ElementTree as ET my_namespaces = dict([node for _, node in ET.iterparse(‘file.xml’, events=[‘start-ns’])]) You don’t need to use StringIO or open(). Just provide the XML filename as an argument to iterparse(). Each item … Read more
You can’t. The XML data type does not preserve CDATA sections. Have a look here for a discussion about the subject. http://social.msdn.microsoft.com/forums/en-US/sqlxml/thread/e22efff3-192e-468e-b173-ced52ada857f/
It is not possible for the input document to be plain text because the input to an XSLT 1.0 transformation must be well-formed XML. Here are some alternative ways to access plain text in an XSLT transformation: Use unparsed-text in XSLT 2.0. Pass the plain text in via top-level parameters (xsl:param). Preprocess the text file … Read more
EDIT: Okay, I think you just want: var sites = from s in xDoc.Element(“sites”).Elements(“site”) orderby (string) s.Attribute(“name”) select s; Which could also be written as: var sites = xDoc.Element(“sites”) .Elements(“site”) .OrderBy(s => (string) s.Attribute(“name”));
First, you must add a targetNamespace=”http://tempuri.org/” to the xs:schema element of your XSD in order for your XSD to apply to the namespace used in your XML payload. Then you can take either of the following approaches: Change the XML or Change the XSD. Choose according to which files you control. Change the XML Add … Read more
This XSL Stylesheet: <xsl:stylesheet version=”1.0″ xmlns:xsl=”http://www.w3.org/1999/XSL/Transform”> <xsl:output indent=”yes”/> <xsl:strip-space elements=”*”/> <xsl:template match=”node()|@*”> <xsl:copy> <xsl:apply-templates select=”node()|@*”/> </xsl:copy> </xsl:template> <xsl:template match=”Field”> <xsl:element name=”{@Name}”> <xsl:value-of select=”@Value”/> </xsl:element> </xsl:template> </xsl:stylesheet> Applied to well-formed input: <SiebelMessage MessageId=”1-18J35″ IntObjectName=”XRX R5 Letter Instance” MessageType=”Integration Object” IntObjectFormat=”Siebel Hierarchical”> <LetterInstance Id=”1-1RUYIF” Language=”ENU” TemplateType=”SA”> <Field Value=”CO Last Name” Datatype=”String” Name=”ContractingOfficerLastName”/> </LetterInstance> </SiebelMessage> Produces: <SiebelMessage MessageId=”1-18J35″ … Read more
This general transformation: <xsl:stylesheet version=”1.0″ xmlns:xsl=”http://www.w3.org/1999/XSL/Transform” xmlns:ns=”some:ns”> <xsl:output omit-xml-declaration=”yes” indent=”yes”/> <xsl:strip-space elements=”*”/> <ns:WhiteList> <name>ns:currency</name> <name>ns:currency_code3</name> </ns:WhiteList> <xsl:template match=”node()|@*”> <xsl:copy> <xsl:apply-templates select=”node()|@*”/> </xsl:copy> </xsl:template> <xsl:template match= “*[not(descendant-or-self::*[name()=document(”)/*/ns:WhiteList/*])]”/> </xsl:stylesheet> when applied on the provided XML document (with namespace definition added to make it well-formed): <ns:stuff xmlns:ns=”some:ns”> <ns:things> <ns:currency>somecurrency</ns:currency> <ns:currency_code/> <ns:currency_code2/> <ns:currency_code3/> <ns:currency_code4/> </ns:things> </ns:stuff> produces the wanted … Read more