Edit XML before comparing with another XML

Question

I am comparing two XML Strings but want to delete some specific ~~attribute~~ element before comparing them.

I want to remove <orderby> ~~attribute~~ element and all data within these tags

XML 1:

<query> <selecttables> <field> <tablerscd>1014</tablerscd> <tablename> OEM IHS Engines</tablename> </field> <orderby> </orderby> </selecttables> </query>

XML 2:

<query> <selecttables> <field> <tablerscd>1014</tablerscd> <tablename> OEM IHS Engines</tablename> </field> <orderby> <columnrscd>1228</columnrscd> <columnrscd>1229</columnrscd> </orderby> </selecttables> </query>

My Question is:

How can i remove <orderby> attribute and all data within these tags before I compare them.

Your xml is invalid. <selecttables> does not have a closing tag. — Phil Blackburn
– Phil Blackburn, Commented Jun 28, 2016 at 7:03
@PhilB I copied specific portion and and xml validity is not the issue — Asim
– Asim, Commented Jun 28, 2016 at 7:05
Having invalid xml will significantly restrict your options and if this is truely not xml then you should remove xml references from the question. — Phil Blackburn
– Phil Blackburn, Commented Jun 28, 2016 at 7:07
@PhilB I have corrected the xml, now you will be able to answer my question ? — Asim
– Asim, Commented Jun 28, 2016 at 7:11

Community · Accepted Answer · 2017-05-23 12:00:56Z

Similar to my own question about removing comments you can do this:

// load your Xml string into an XDocument var xml = XDocument.Parse(yourxmlstringhere); foreach (var node in xml.SelectNodes("//orderby").ToList()) { node.ParentNode.RemoveChild(node); }

Which will find all orderbyelements, navigate to their parent element and delete them from there.

I adopted this answer from Anthony, who pointed out that it will be safer to create a List before removing.

Charles Mager · Accepted Answer · 2016-06-28 08:43:41Z

You can do this very trivially using LINQ to XML:

var doc = XDocument.Parse(xml); doc.Descendants("orderby").Remove();

See this fiddle for a demo.

Collectives™ on Stack Overflow

Edit XML before comparing with another XML

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related