Break xml in to multiple xml using C#

Question

I have a XML file. I am looлing for help to create multiple xml files from this xml file where ever it find different EmplId.

I tried to retrieve the distinct EmplId But not sure how to break the xml and loop through the entire xml file further.

Xml looks like this -

<?xml version="1.0" encoding="utf-8"?>
<Connected>
  <Emp>
    <A.EMPLID>1</A.EMPLID>
    <A.Phone>12##</A.Phone>
  </Emp>
  <Emp>
    <A.EMPLID>1</A.EMPLID>
    <A.Add>XXXXXXX</A.Add>
  </Emp>
  <Emp>
    <A.EMPLID>2</A.EMPLID>
    <A.Phone>##34</A.Phone>
  </Emp>
  <Emp>
    <A.EMPLID>3</A.EMPLID>
  </Emp>
  <Emp>
    <A.EMPLID>3</A.EMPLID>
    <A.Add>XXXXXXX</A.Add>
  </Emp>
</Connected>

Output will be 3 different Xml for 3 different EmplId

First Xml EmplID =1

<?xml version="1.0" encoding="utf-8"?>
<Connected>
  <Emp>
    <A.EMPLID>1</A.EMPLID>
    <A.Phone>12##</A.Phone>
    <A.Add>XXXXXXX</A.Add>
  </Emp>
</Connected>

Second Xml EmplId = 2

<?xml version="1.0" encoding="utf-8"?>
<Connected>
  <Emp>
    <A.EMPLID>2</A.EMPLID>
    <A.Phone>##34</A.Phone>
  </Emp>
</Connected>

Third Xml - EmplId = 3

<?xml version="1.0" encoding="utf-8"?>
<Connected>
  <Emp>
    <A.EMPLID>3</A.EMPLID>
    <A.Add>XXXXXXX</A.Add>
  </Emp>
</Connected>

I have used below code to count distinct emplid

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load("C:/Sample - code test.xml");
XmlNodeList count = xmlDoc.SelectNodes(@"//Connected/Emp/A.EMPLID");

int i = count.Cast<XmlNode>().Select(a => a.InnerText).Distinct().Count();
Console.WriteLine(i);

Possible duplicate of How to Split an XML file into multiple XML Files based on nodes — Sebastian Hofmann
– Sebastian Hofmann, Commented May 8, 2018 at 13:24
Thanks for reply . But I am not trying to break xml at each node. I have merged nodes if empl id is same. e.g EmplId =1 I have merged to create a one file — user2897967
– user2897967, Commented May 8, 2018 at 13:32

Alexander Petrov · Accepted Answer · 2018-05-08 13:49:26Z

2

Linq2xml much more convenient.

var xml = XElement.Load("test.xml");

var grouped = xml.Elements("Emp")
    .GroupBy(emp => emp.Element("A.EMPLID").Value);

foreach (var group in grouped)
{
    var x = new XElement("Connected",
        new XElement("Emp",
            new XElement("A.EMPLID", group.Key),
            group.Select(g => g.Elements().Where(e => e.Name != "A.EMPLID"))));

    x.Save("file" + group.Key + ".xml");
}

answered May 8, 2018 at 13:49

Alexander Petrov

14.4k2 gold badges23 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Break xml in to multiple xml using C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related