How to delete nodes from XML with exact string match in c#

Question

I have below xml. I want to delete those nodes which doesn't contains attributes. in below xml I want to delete last 4 nodes which doesn't have attributes.

XML

<products>
    <product system="kn-movies" code="UR">Unrated</product>
    <product system="mu-movies" code="UR">Unrated</product>
    <product system="na-movies" code="UR">Unrated</product>
    <product system="fj-movies" code="UR">Unrated</product>
    <product>Unrated (Unrated )</product>
    <product>Unrated (Unrated )</product>
    <product>Unrated (Без классификации )</product>
    <product>Unrated (غير مصنف )</product>
</products>

I had tried this c# code

var ratingNode = document.Descendants("rating").Where(t => t != null && t.Equals(Convert.ToString(nodeItem))).FirstOrDefault();
                            if (ratingNode != null)
                            {
                                ratingNode.Remove();
                            }

but it doesn't worked for me. please help me out where i m doing mistakes.

kashi_rock · Accepted Answer · 2016-07-26 04:44:41Z

2

System.Xml.Linq.XDocument doc = System.Xml.Linq.XDocument.Load(filepath);
var newList = doc.Root.Descendants().ToList().RemoveAll(x => x.Attributes() == null || x.Attributes().Count() <= 0);

Hope it helps!!

answered Jul 26, 2016 at 4:44

kashi_rock

5571 gold badge5 silver badges19 bronze badges

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

Comments

Mohit S · Accepted Answer · 2016-07-26 04:21:05Z

1

Hope this will do trick

XmlNodeList nodes = xmlDocument.GetElementsByTagName("products");
foreach(XmlNode node in nodes)
{
    if(node.Attributes.Count == 0)
    {
        node.RemoveAll;
    }
}

answered Jul 26, 2016 at 4:21

Mohit S

14.1k6 gold badges36 silver badges73 bronze badges

Comments

Hari Prasad · Accepted Answer · 2016-07-26 04:37:25Z

1

You could use Linq to Xml and query for elements which has no attributes, then you just need Remove call to remove those elements.

XDocument doc = XDocument.Load(filepath);       
doc.Root
   .Descendants()                             // flattens the structure 
   .Where(x=> x.Attributes().Count() <= 0)     // filter elements which has no attributes
   .Remove();                                 // Remove them

Check this Demo

edited Jul 26, 2016 at 4:37

answered Jul 26, 2016 at 4:30

Hari Prasad

17k4 gold badges23 silver badges35 bronze badges

Collectives™ on Stack Overflow

How to delete nodes from XML with exact string match in c#

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related