Removing empty XML node using XSLT

Question

I am looking for a help I am writting a XSL to remove empty nodes, it is working but If I have xsi:xsi = true in one of the XML node, then it is not removing that node, I need style sheet which remove empty node, empty attributes and node which contain xsi:xsi = true

INPUT XML

<root>
<para>
 <Description>This is my test description</Description>
 <Test></Test>
 <Test1 attribute="1"/>
 <Received_Date xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
</para>
</root>

OutPut XML

<root>
<para>
 <Description>This is my test description</Description> 
 <Test1 attribute="1"/>
 <Received_Date xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
</para>

Expected Output

<root>
<para>
 <Description>This is my test description</Description> 
 <Test1 attribute="1"/>
</para>
</root>

XSL Code

<?xml version="1.0" ?>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
    <xsl:output omit-xml-declaration="yes" indent="yes" />
    <xsl:template match="node()|SDLT">
        <xsl:if test="count(descendant::text()[string-length(normalize-space(.))>0]|@*)">
            <xsl:copy>
                <xsl:apply-templates select="@*|node()" />
            </xsl:copy>
        </xsl:if>

    </xsl:template>
    <xsl:template match="@*">
        <xsl:copy />
    </xsl:template>
    <xsl:template match="text()">
        <xsl:value-of select="normalize-space(.)" />
    </xsl:template>

</xsl:stylesheet>

xsi:nil is an attribute, and your stylesheet does not consider an element with an attribute as "empty". — michael.hor257k
– michael.hor257k, Commented Sep 5, 2017 at 18:25
Also, why do you match for elements named SDLT? This element doesn't seem to exist in any of your input files, and anyway, that would already be covered by matching on any node(). — Eiríkr Útlendi
– Eiríkr Útlendi, Commented Sep 5, 2017 at 20:36
Yes I do agree, We dont need SDLT. For me I need to remove element which is having attribute xsi:nil = true — user2631055
– user2631055, Commented Sep 6, 2017 at 2:58

Rupesh_Kr · Accepted Answer · 2017-09-06 05:19:13Z

1

You can use this:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    version="1.0">
    <xsl:output omit-xml-declaration="yes" indent="yes" />
    <xsl:template match="node()|SDLT">
        <xsl:if test="(node() or @* ) and not(@xsi:nil = 'true')">
            <xsl:copy>
                <xsl:apply-templates select="@*|node()" />
            </xsl:copy>
        </xsl:if>

    </xsl:template>

    <xsl:template match="@*">
        <xsl:copy />
    </xsl:template>

    <xsl:template match="text()">
        <xsl:value-of select="normalize-space(.)" />
    </xsl:template>

</xsl:stylesheet>

answered Sep 6, 2017 at 5:19

Rupesh_Kr

3,4572 gold badges19 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Removing empty XML node using XSLT

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related