XSLT Exclude Empty Elements
I'm a rank amateur when it comes to XSLT. I have a stylesheet that works except that I need to exclude empty elements. It's a long stylesheet, so here is an abbreviated version.
The input looks like this
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:strip-space elements="*"/>
<xsl:output method = "xml" indent = "yes" />
<!--
This is a transform to create an XML file from the ANX file output by the Debt Collection HotDocs intake.
-->
<xsl:template match="/AnswerSet">
<xsl:element name="OnlineIntake">
.
.
.
<xsl:for-each select="//Answer[@name='Factor']/RptValue/MCValue">
<xsl:variable name="getfactors" select="position()"/>
<xsl:element name="Factors">
<xsl:element name="Factor">
<xsl:value-of select="//Answer[@name='Factor']//MCValue[$getfactors]"/>
</xsl:element>
<xsl:element name="FactorAmt">
<xsl:value-of select="//Answer[@name='FactorAmount']//NumValue[$getfactors]"/>
</xsl:element>
</xsl:element> <!-- Factors -->
</xsl:for-each> <!-- end of foreach for Factors -->
The input looks like this
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<AnswerSet title="" version="1.1">
<Answer name="(ANSWER FILE HISTORY)">
<TextValue>Debt Collection Intake : May 6, 2015, 15:15
Maintenance Interview : February 18, 2015, 15:34
</TextValue>
.
.
.
<Answer name="Factor">
<RptValue>
<MCValue>
<SelValue>Child Care/Work-Related</SelValue>
</MCValue>
<MCValue>
<SelValue>Current income taxes</SelValue>
</MCValue>
<MCValue>
<SelValue>Mortgage payments</SelValue>
</MCValue>
<MCValue>
<SelValue>Rent</SelValue>
</MCValue>
<MCValue>
<SelValue>Transportation Expenses/Work-Related</SelValue>
</MCValue>
<MCValue>
<SelValue>Tools & Equipment/Work-Related</SelValue>
</MCValue>
<MCValue unans="true"/>
</RptValue>
</Answer>
<Answer name="Factor">
<RptValue>
<MCValue>
<SelValue>Child Care/Work-Related</SelValue>
</MCValue>
<MCValue>
<SelValue>Current income taxes</SelValue>
</MCValue>
<MCValue>
<SelValue>Mortgage payments</SelValue>
</MCValue>
<MCValue>
<SelValue>Rent</SelValue>
</MCValue>
<MCValue>
<SelValue>Transportation Expenses/Work-Related</SelValue>
</MCValue>
<MCValue>
<SelValue>Tools & Equipment/Work-Related</SelValue>
</MCValue>
<MCValue unans="true"/>
</RptValue>
</AnswerSet>
<Factors>
<Factor>Child Care/Work-Related</Factor>
<FactorAmt>100.0000000</FactorAmt>
</Factors>
<Factors>
<Factor>Current income taxes</Factor>
<FactorAmt>250.0000000</FactorAmt>
</Factors>
<Factors>
<Factor>Mortgage payments</Factor>
<FactorAmt>600.0000000</FactorAmt>
</Factors>
<Factors>
<Factor>Rent</Factor>
<FactorAmt>0.0000000</FactorAmt>
</Factors>
<Factors>
<Factor>Transportation Expenses/Work-Related</Factor>
<FactorAmt>100.0000000</FactorAmt>
</Factors>
<Factors>
<Factor>Tools & Equipment/Work-Related</Factor>
<FactorAmt>75.0000000</FactorAmt>
</Factors>
<Factors>
<Factor/>
<FactorAmt/>
</Factors>
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:strip-space elements="*"/>
<xsl:output indent="yes"/>
<xsl:template match="/AnswerSet">
<xsl:element name="OnlineIntake">
<xsl:apply-templates select="//Answer[@name='Factor']/RptValue/MCValue"></xsl:apply-templates>
</xsl:element>
</xsl:template>
<xsl:template match="Answer[@name='Factor']/RptValue/MCValue">
<xsl:variable name="getfactors" select="position()"/>
<xsl:variable name="amt" select="(//Answer[@name='FactorAmount'])[$getfactors]//NumValue"></xsl:variable>
<xsl:if test="normalize-space(SelValue) or normalize-space($amt)">
<xsl:element name="Factors">
<xsl:element name="Factor">
<xsl:value-of select="SelValue"/>
</xsl:element>
<xsl:element name="FactorAmt">
<xsl:value-of select="$amt"/>
</xsl:element>
</xsl:element>
</xsl:if>
</xsl:template>
</xsl:stylesheet>
The short answer is... add a simple xsl:if before you output the element to the result tree
But I saw some other ways of improvement
jumping up the tree and come back to basically the same element node is expensive
Your source XML had obvious errors because you cut away some stuff,
but basically I think you need to add brackets and positional predicates at the right place to address the correct node
And I restructured a bit... you should use apply-templates over for-each whenever possible (and that means almost always :-)
But I saw some other ways of improvement
jumping up the tree and come back to basically the same element node is expensive
Your source XML had obvious errors because you cut away some stuff,
but basically I think you need to add brackets and positional predicates at the right place to address the correct node
And I restructured a bit... you should use apply-templates over for-each whenever possible (and that means almost always :-)
Thank you, Geert. I knew I needed to use apply-template but I couldn't figure out how to write it. And I love the simplicity of your answer! I inherited the transform and I plan to re-write all of it when I get a chance because I know it's kind of kludgy.
The code you gave me works for getting all the Factors but it's only picking up the first FactorAmt. I've been trying to understand the code you wrote but I can't figure out what I need to add to get all the FactorAmts.
The code you gave me works for getting all the Factors but it's only picking up the first FactorAmt. I've been trying to understand the code you wrote but I can't figure out what I need to add to get all the FactorAmts.
Ah, I've got it! I made one change in your code and I got all of the factors and their amounts. Your code was
Thanks so much for your help!
<xsl:variable name="amt" select="(//Answer[@name='FactorAmount'])[$getfactors]//NumValue"></xsl:variable>
<xsl:variable name="amt" select="(//Answer[@name='FactorAmount'])//NumValue[$getfactors]"></xsl:variable>
Thanks so much for your help!
Premium Content
You need an Expert Office subscription to comment.Start Free Trial