Remove parent node in xml if child node contains a particular string

Question

I have an xml document:

<xml>
<duplication>
 <file path="C:\Hello\Test.Designer.cs" />
 <file path="C:\Hello\Demo.Designer.cs" />
</duplication>
<duplication>
 <file path="C:\Hello\Test.cs" />
 <file path="C:\Hello\Demo.cs" />
</duplication>
</xml>

So if duplication node contains .Designer.cs file in file child then i want it to remove the entire node. So the output should be:

<xml>
<duplication>
<file path="C:\Hello\Test.Designer.cs" />
<file path="C:\Hello\Demo.Designer.cs" />
</duplication>
</xml>

What would be best way to do it? I would be running that on build pipeline in Azure. So i do not want heavy piece of code.

How about XSLT approach?

Yitzhak Khabinsky
– Yitzhak Khabinsky

2020-10-20 15:35:04 +00:00
Commented Oct 20, 2020 at 15:35 — Yitzhak Khabinsky
– Yitzhak Khabinsky, Commented Oct 20, 2020 at 15:35
that would work

Prakash Kumar
– Prakash Kumar

2020-10-20 15:44:06 +00:00
Commented Oct 20, 2020 at 15:44 — Prakash Kumar
– Prakash Kumar, Commented Oct 20, 2020 at 15:44

Yitzhak Khabinsky · Accepted Answer · 2020-10-20 20:08:52Z

1

Please try the following XSLT.

XSLT 2.0

<?xml version="1.0"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" encoding="utf-8" indent="yes"/>
    <xsl:strip-space elements="*"/>

    <xsl:template match="@*|node()">
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>

    <xsl:template match="duplication[file[not(ends-with(@path, '.Designer.cs'))]]">
    </xsl:template>
</xsl:stylesheet>

XSLT 1.0

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml" encoding="utf-8" indent="yes"/>
    <xsl:strip-space elements="*"/>

    <xsl:template match="@*|node()">
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>

    <xsl:template match="duplication[file[not(contains(@path, '.Designer.cs'))]]">
    </xsl:template>
</xsl:stylesheet>

edited Oct 20, 2020 at 20:08

answered Oct 20, 2020 at 15:56

Yitzhak Khabinsky

22.9k2 gold badges19 silver badges25 bronze badges

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

10 Comments

Prakash Kumar Over a year ago

how do i run this? and what if i wanted to add more parameters?

Yitzhak Khabinsky Over a year ago

Azure Logic App., it has Maps functionality.

Prakash Kumar Over a year ago

i get an error, XSLT compile error, the files i am accessing is xml verison 1. if i change to version 1.0, it says ends-with() is unknown function

Yitzhak Khabinsky Over a year ago

Azure Logic App. maps support XSLT 1.0, 2.0, and 3.0. When you create a new map, it allows to select version of XSLT

Prakash Kumar Over a year ago

i am trying to run through console app in C#

|

Collectives™ on Stack Overflow

Remove parent node in xml if child node contains a particular string

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related