Removing XML Nodes using XSLT

Question

I have the following XML:

<?xml version="1.0" encoding="utf-8"?>
<Rowsets>
<Rowset>
    <Columns>
        <Column Description="FirstName" MaxRange="1" MinRange="0" Name="FirstName" SQLDataType="12" SourceColumn="FirstName"/>
        <Column Description="LastName" MaxRange="1" MinRange="0" Name="LastName" SQLDataType="12" SourceColumn="LastName"/>
        <Column Description="Phone" MaxRange="1" MinRange="0" Name="Phone" SQLDataType="1" SourceColumn="Phone"/>
    </Columns>
    <Row>
        <FirstName>Michael</FirstName>
        <LastName>David</LastName>
        <Phone>1234567890</Phone>
    </Row>
    <Row>
        <FirstName>David</FirstName>
        <LastName>Michael</LastName>
        <Phone>01234567890</Phone>
    </Row>
    <Row>
        <FirstName>Yang</FirstName>
        <LastName>Christina</LastName>
        <Phone>2345678901</Phone>
    </Row>
    <Row>
        <FirstName>Grey</FirstName>
        <LastName>Meredith</LastName>
        <Phone>3456789012</Phone>
    </Row>
    <Row>
        <FirstName>David</FirstName>
        <LastName>Shepherd</LastName>
        <Phone>5678901234</Phone>
    </Row>
</Rowset>

I want to remove <Phone> node from every Row as well as from Column description.

SO my resultant XML would look like following:

<?xml version="1.0" encoding="utf-8"?>
<Rowsets>
<Rowset>
    <Columns>
        <Column Description="FirstName" MaxRange="1" MinRange="0" Name="FirstName" SQLDataType="12" SourceColumn="FirstName"/>
        <Column Description="LastName" MaxRange="1" MinRange="0" Name="LastName" SQLDataType="12" SourceColumn="LastName"/>
    </Columns>
    <Row>
        <FirstName>Michael</FirstName>
        <LastName>David</LastName>
    </Row>
    <Row>
        <FirstName>David</FirstName>
        <LastName>Michael</LastName>
    </Row>
    <Row>
        <FirstName>Yang</FirstName>
        <LastName>Christina</LastName>
    </Row>
    <Row>
        <FirstName>Grey</FirstName>
        <LastName>Meredith</LastName>
    </Row>
    <Row>
        <FirstName>David</FirstName>
        <LastName>Shepherd</LastName>
    </Row>
</Rowset>

How do I achieve that? I tried various XSLT but I am not able to do it.

Sean B. Durkin · Accepted Answer · 2012-08-28 04:53:53Z

38

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

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

<xsl:template match="Column[@SourceColumn='Phone']|Phone" />

</xsl:stylesheet>

answered Aug 28, 2012 at 4:53

Sean B. Durkin

12.8k2 gold badges39 silver badges73 bronze badges

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

5 Comments

Soham Shah Over a year ago

Hi Sean. Thanks for the answer. It does suffice my requirements. But I did not understand how does it achive that? Can you please explain the XSLT?

Sean B. Durkin Over a year ago

The first template copies everything as is from the input document, except for the nodes that match the second template. The second template matches elements with name Phone or elements with name Column and attribute SourceColumn=Phone. For these nodes, do nothing. That is to say, delete them.

Blub Over a year ago

"except for the nodes that match the second template" where does it do that exception?

Sean B. Durkin Over a year ago

@Blub: When the conditions are that both templates match, the template with the most specific match criteria prevails. So for example, when the element is 'Phone', both templates match, but the second template is more specific, so it wins.

George Chakhidze Over a year ago

Also, keep in mind, while this particular example XML does not have namespaces, you will have to include them in your XPath if you have XML with namespaces.

Collectives™ on Stack Overflow

Removing XML Nodes using XSLT

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related