Filter XML based on attribute value using xslt

Question

I have searched here and I'm not able to find how to filter an xml based on their attribute. I have this xml:





     <?xml version="1.0" encoding="utf-8"?>
        <document>
            <document_head>
                <title>This is the title</title>
                <version>This is the title</version>
            </document_head>
            <document_body>
                <paragraph id="AXD">
                    <text>
                        This is a text that should be in the result
                    </text>
                    <properties>
                        <size>13px</size>
                        <color>#000000</color>
                    </properties>
                    <author>Current user</author>
                </paragraph>
                <paragraph id="SFI">
                    <properties>
                        <text>
                            This is some other text that should not be in there
                        </text>
                    </properties>
                </paragraph>
                <paragraph id="SFA">
                    <author>Some random guy</author>
                </paragraph>      
                <paragraph id="ARG">
                    This doesn't mean anything.
                </paragraph>
                <paragraph id="RRR">
                    This does, hence should be in there.
                </paragraph>
            </document_body>
        </document>

I expect this result:



    <?xml version="1.0" encoding="UTF-8"?>
    <document>
        <document_head>
            <title>This is the title</title>
            <version>This is the title</version>
        </document_head>
        <document_body>
            <paragraph id="AXD">
                <text>
                    This is a text that should be in the result
                </text>
                <properties>
                    <size>13px</size>
                    <color>#000000</color>
                </properties>
                <author>Current user</author>
            </paragraph>
            <paragraph id="RRR">
                This does, hence should be in there.
            </paragraph>      
        </document_body>
    </document>

Currently, I have this XSLT:



    <?xml version="1.0" encoding="utf-8"?>
    <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
      <xsl:output method="xml" indent="yes"/>  
      <xsl:template match="@* | node()">
        <xsl:copy>
          <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
      </xsl:template>

      <xsl:template match="document_body/paragraph[not(@id='AXD')][not(@id='RRR')]" />
    </xsl:stylesheet>

Which produces this XML:





     <?xml version="1.0" encoding="UTF-8"?>
        <document>
            <document_head>
                <title>This is the title</title>
                <version>This is the title</version>
            </document_head>
            <document_body>
                <paragraph id="AXD">
                    <text>
                        This is a text that should be in the result
                    </text>
                    <properties>
                        <size>13px</size>
                        <color>#000000</color>
                    </properties>
                    <author>Current user</author>
                </paragraph>      
            </document_body>
        </document>

Do you know what I am missing?

Thanks.

Update: It seems that the code works for another XSLT processor, but it doesn't for Java Transformer.

Are you sure it is not working? I just tried, and it did produce your expected output! — Tim C
– Tim C, Commented Jul 18, 2012 at 16:23
@tim-c Hi Tim. Yes, I tried it several times using Java, and nothing. It gives me the result that I posted. It seems that it is not checking for the second condition :( — Ondino
– Ondino, Commented Jul 18, 2012 at 16:34

Tim C · Accepted Answer · 2012-07-18 16:51:08Z

8

I am sure your condition should work! However, here is couple of alternative ways to check, so give this a go instead to see if that makes a difference.

<xsl:template match="document_body/paragraph[not(@id='AXD' or @id='RRR')]"/>

<xsl:template match="document_body/paragraph[@id != 'AXD' and @id != 'RRR']"/>

edited Jul 18, 2012 at 16:51

answered Jul 18, 2012 at 16:39

Tim C

70.7k14 gold badges77 silver badges94 bronze badges

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

3 Comments

Ondino Over a year ago

It works! Thanks a lot. Side question: Is it possible to change that OR by AND for comparisons? I know it is kind of unrelated, but it saves me another question here.

Tim C Over a year ago

I am not sure I fully understand, but I have edited by answer just in case. Perhaps another question would be best, there is no harm in that!

Ondino Over a year ago

Sorry about that. It was about the operator itself. And yes, both of the answers work. Thanks a lot.

Collectives™ on Stack Overflow

Filter XML based on attribute value using xslt

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related