Setting node vale to specific string when it is null or empty using XSLT 1.0

Question

I have the following input xml:

 <?xml version="1.0" encoding="UTF-8"?>
    <GroupMainRequest>
       <GroupMainResults>
          <GroupNumber>GLEN01</GroupNumber>
          <divisions>
             <userProvidedEffDate>12/31/1998</userProvidedEffDate>
             <division>
                <GroupNumber>GLEN010001</GroupNumber>
                <GroupEffDt>01/01/2000</GroupEffDt>
                <GroupExpDt />
             </division>
             <division>
                <GroupNumber>GLEN010002</GroupNumber>
                <GroupEffDt>01/01/2000</GroupEffDt>
                <GroupExpDt />
             </division>
             <division>
                <GroupNumber>GLEN010003</GroupNumber>
                <GroupEffDt>01/01/2000</GroupEffDt>
                <GroupExpDt>12/31/2001</GroupExpDt>
             </division>
          </divisions>
       </GroupMainResults>
    </GroupMainRequest>

I need to update the value of the node <GroupExpDt> of each <division> under <divisions> to 12/31/9999 whenever the node value is empty or null( I am using XSLT 1.0).

The final xml output should be as below:

<?xml version="1.0" encoding="UTF-8"?>
    <GroupMainRequest>
       <GroupMainResults>
          <GroupNumber>GLEN01</GroupNumber>
          <divisions>
             <userProvidedEffDate>12/31/1998</userProvidedEffDate>
             <division>
                <GroupNumber>GLEN010001</GroupNumber>
                <GroupEffDt>01/01/2000</GroupEffDt>
                <GroupExpDt>12/31/9999</GroupExpDt>
             </division>
             <division>
                <GroupNumber>GLEN010002</GroupNumber>
                <GroupEffDt>01/01/2000</GroupEffDt>
                <GroupExpDt>12/31/9999</GroupExpDt>
             </division>
             <division>
                <GroupNumber>GLEN010003</GroupNumber>
                <GroupEffDt>01/01/2000</GroupEffDt>
                <GroupExpDt>12/31/2001</GroupExpDt>
             </division>
          </divisions>
       </GroupMainResults>
    </GroupMainRequest>

Any help is much appreciated.

"I need" is not a question. Where exactly are you stuck with this? — michael.hor257k
– michael.hor257k, Commented Jun 3, 2019 at 7:40

Christian Mosz · Accepted Answer · 2019-06-03 14:24:52Z

1

Related to another question: Copy all nodes with special cases

So upvote his answer too please ;)

Transformed his code a bit:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<!-- Identity template, provides default behavior that copies all content into the output -->
<xsl:template match="@*|node()">
    <xsl:copy>
        <xsl:apply-templates select="@*|node()"/>
    </xsl:copy>
</xsl:template>

<!-- More specific template for GroupExpDt that provides custom behavior -->
<!-- Documentation below code block -->
<xsl:template match="GroupExpDt[string-length(normalize-space(text())) = 0]">  
    <GroupExpDt>
        <xsl:text>12/31/9999</xsl:text>
    </GroupExpDt>
</xsl:template>
</xsl:stylesheet>

normalize-space() documentation

answered Jun 3, 2019 at 14:24

Christian Mosz

5433 silver badges12 bronze badges

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

1 Comment

Tim C Over a year ago

You could slightly simplify the template match to <xsl:template match="GroupExpDt[not(normalize-space())]">.

Collectives™ on Stack Overflow

Setting node vale to specific string when it is null or empty using XSLT 1.0

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related