C# XML File Split

rangeshram · May 24th, 2010, 12:15 PM

Hi,

We need to Split the XML files based on the Element "CASE". While splitting it is converting Hexadecimal entities into UTF entities. We're new to this, you can understand our level of standard by analyzing the codings.

Please see the XML file and Csharp File for xml Conversion.

XML File

Code:

<ROOT>
<CASE>
<TB>U. S. DISTRICT COURT, EASTERN DISTRICT OF TEXAS</TB>
<LC>CAMPBELL V. WATTS</LC>, <DN>No. 70</DN>, <DD>Feb. 23, 1942</DD>
<SL>FAIR LABOR STANDARDS ACT</SL>
<DE>&#x2014; Overtime standard &#x2014; Burden of proof&#x2014;Evidence</DE>
<PA>In action to recover unpaid overtime compensation under Act, employee has burden of showing with definiteness and certainty that he worked overtime.</PA>
</CASE>
<CASE>
<TB>2nd Chance</TB>
<LC>CAMPBELL V. WATTS</LC>, <DN>No. 70</DN>, <DD>Feb. 23, 1942</DD>
<SL>FAIR LABOR STANDARDS ACT</SL>
<DE>&#x2014; Overtime standard &#x2014; Burden of proof&#x2014;Evidence</DE>
<PA>In action to recover unpaid overtime compensation under Act, employee has burden of showing with definiteness and certainty that he worked overtime.</PA>
</CASE>
</ROOT>

CSharp Coding

Code:

XmlDocument xmlReXML = new XmlDocument();
xmlReXML.Load(@"c:\Shorttag.xml");

XmlNodeList xnRep = xmlReXML.DocumentElement.GetElementsByTagName("CASE");

string strFileName = "CASE";
int intFileCount;

for(int i =0; i <xnRep.Count;i++)
{
              //Stores the CASE Elements in the Variable
              strDest = xnRep[i].InnerXml;

              //Create the New File with the name "CASE_1.xml" and "CASE_3.xml" 
              XmlWriter xw = XmlWriter.Create(strFileName + "_" + intFileCount + ".xml");

              //Write the XML
              xw.WriteRaw(strDest.ToString());

              xw.Close();

              intFileCount++;
}

Current Output

Code:

Ã¯Â»Â¿<?xml version="1.0" encoding="utf-8"?><TB>U. S. DISTRICT COURT, EASTERN DISTRICT OF TEXAS</TB><LC>CAMPBELL V. WATTS</LC>, <DN>No. 70</DN>, <DD>Feb. 23, 1942</DD><SL>FAIR LABOR STANDARDS ACT</SL><DE>Ã¢â¬â Overtime standard Ã¢â¬â Burden of proofÃ¢â¬âEvidence</DE><PA>In action to recover unpaid overtime compensation under Act, employee has burden of showing with definiteness and certainty that he worked overtime.</PA><PA>Evidence held not to show with definiteness and certainty that employee worked an average of 16 hours a day as he claims, precluding him from recovering from employer overtime compensation under Act.</PA>

We need to split the xml file by retaining the entities and also its structure(entermarks) like the original.

Expecting your kind support to solve this..

gbianchi · May 24th, 2010, 12:46 PM

Hi there..

And your problem is????

rangeshram · May 25th, 2010, 02:18 AM

Hi,

From our Csharp code, we can successfully split the XML file but the problem is we have to retain the entities as in the original file (e.g., — instead of Ã¢â¬â) and also its structures (you can see the XML Elements is wraped).

This is the summary of the problem we're facing. Please suggest how to solve this. If you need any other information, kindly let us know

Thanks,

rangeshram · May 26th, 2010, 06:43 AM

Dear All,

Kindly look into these post and help us how to avoid UTF encoding rather than — which is our client requirement.

joefawcett · May 26th, 2010, 07:15 AM

Basically references are treated the same as the characters themselves when the file is read so what you want is not possible for all circumastances as it's not possible to tell which characters were represented which way. If you know that the output must be in a specific character set then you can specify this using the XmlWriterSettings Encoding property. http://msdn.microsoft.com/en-us/libr...z3(VS.80).aspx

rangeshram · May 27th, 2010, 08:00 AM

Thanks joefawcett for your suggestion to use XMLWritter Settings to write XML file.

We have modified our coding by using writter settings:

::CSharp Code::

Code:

XmlDocument xmlReXML = new XmlDocument();
xmlReXML.Load(@"c:\Shorttag.xml");

xmlReXML.PreserveWhitespace = true;

XmlNodeList xnRep = xmlReXML.DocumentElement.GetElementsByTagName("CASE");

string strFileName = "CASE";
int intFileCount;

for(int i =0; i <xnRep.Count;i++)
{
              //Stores the CASE Elements in the Variable
              strDest = xnRep[i].InnerXml;


		//Initialize the XMLWritter class settings
                XmlWriterSettings xwsettings = new XmlWriterSettings();
                xwsettings.CheckCharacters = true;
                xwsettings.CloseOutput = false;
                xwsettings.ConformanceLevel = ConformanceLevel.Fragment;
                xwsettings.NewLineChars = Environment.NewLine;
                xwsettings.NewLineOnAttributes = false;
                xwsettings.NewLineHandling = NewLineHandling.Entitize;
                xwsettings.OmitXmlDeclaration = true;
                xwsettings.Encoding = Encoding.ASCII;	

              //Create the New File with the name "CASE_1.xml" and "CASE_3.xml" 
              XmlWriter xw = XmlWriter.Create(strFileName + "_" + intFileCount + ".xml", xwsettings);

              //Write the XML
              xw.WriteString(strDest.ToString());

              xw.Close();

              intFileCount++;
}

Note: Using the above code we will retain the existing entities. The only drawback with the above code is that it will automatically convert the <, > for <> angle brackets tags also.

We Hope the above code will help some others whose objective is to split the XML file and retain the Entities in the XML file.

joefawcett · May 27th, 2010, 08:30 AM

I think that's because you are using the WriteString method combined with storing the InnerXml in a string.

I would have done the whole transformation via XSLT but as an alternative you could use an XmlReader and use the WriteNode method instead: http://msdn.microsoft.com/en-us/library/1wd6aw1b.aspx