CODEWITHSUNDEEP
c#xml
Moe R
Moe R

Reputation: 73

Split XML file in C#

I have an XML file which have multiple messages in one large file, my objective it to split the file into singe xml file for each message, I have a c# code which only gets me the first instance of the message. can you please tell what am I missing here:

Here is my code :

      string strSeq;
      string strFileName;
      XDocument doc = XDocument.Load(@"C:\XMl\MR.xml");
      var newDocs = doc.Descendants("Message")
               .Select(d => new XDocument(new XElement("FileDump", d)));
             foreach (var newDoc in newDocs)
              {
               strSeq = XDocument.Load(@"C:\XMl\MR.xml").XPathSelectElement
               "//FileDump/Message/MsgID").Value;           

                strFileName = "MR_" + strSeq + ".xml";
                newDoc.Save(Console.Out); Console.WriteLine();
                newDoc.Save(@"C:\xml\MR\Tst\" + strFileName);
                Console.WriteLine();
               }

Upvotes: 1

Views: 659

Answers (2)

Chuck Savage
Chuck Savage

Reputation: 11955

Try,

string path = @"C:\xml\MR\Tst\MR_";

XElement root = XElement.Load(file);
foreach(XElement message in root.Descendants("Message"))
{
    string id = message.Element("MsgID").Value;
    message.Save(path + id + ".xml");
}

Upvotes: 0

MarcinJuraszek
MarcinJuraszek

Reputation: 125660

You should search for message ID within newDoc instead of doc:

foreach (var newDoc in newDocs)
{
    strSeq = newDoc.XPathSelectElement("//FileDump/Message/MsgID").Value;           

    strFileName = "MR_" + strSeq + ".xml";
    newDoc.Save(Console.Out); Console.WriteLine();
    newDoc.Save(@"C:\xml\MR\Tst\" + strFileName);
    Console.WriteLine();
}

Upvotes: 1

Related Questions