How to extract specific value from XML either using Xpath or XSLT

Question

I need to extract value for each AvamarGrid on the basis of Day.

  <AvamarGridTime Day="Monday">
    <AvamarGrid>frk-opavautl921</AvamarGrid>
  </AvamarGridTime>
  <AvamarGridTime Day="Tuesday">
    <AvamarGrid>ftc-opavautl961</AvamarGrid>
    <AvamarGrid>ftc-opavbutl921</AvamarGrid>
    <AvamarGrid>ptc-opavautl981</AvamarGrid>
  </AvamarGridTime>
  <AvamarGridTime Day="Wednesday">
    <AvamarGrid>lhr-opavautl941</AvamarGrid>
  </AvamarGridTime>
a
  <AvamarGridTime Day="Thursday">
    <AvamarGrid>sf1-its-bku-t01</AvamarGrid>
    <AvamarGrid>sf1-opavautl901</AvamarGrid>
  </AvamarGridTime>
  <AvamarGridTime Day="Friday">
    <AvamarGrid>par-opavautl921</AvamarGrid>
  </AvamarGridTime>
</AvamarGrids>

I am using below XSLT

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
  <xsl:output indent="no" />
  <xsl:template match="/">
    <Day>
      <xsl:for-each select="//AvamarGridTime">
        <xsl:if test="//AvamarGridTime[@Day=&quot;Monday&quot;]">
          <xsl:value-of select="AvamarGrid" disable-output-escaping="no" />
        </xsl:if>
      </xsl:for-each>
    </Day>
  </xsl:template>
</xsl:stylesheet>

But, getting below output, instead of just : frk-opavautl921

<?xml version="1.0" encoding="UTF-8"?><Day>frk-opavautl921ftc-opavautl961lhr-opavautl941sf1-its-bku-t01par-opavautl921</Day>

michael.hor257k · Accepted Answer · 2020-02-24 17:46:56Z

1

Your test:

<xsl:if test="//AvamarGridTime[@Day=&quot;Monday&quot;]">

checks the existence of a AvamarGridTime element whose Day attribute is Monday in the entire XML input. This returns true for every one of the checked nodes. To test only the current node, change it to:

<xsl:if test="@Day=&quot;Monday&quot;">

Or do simply:

<xsl:template match="/AvamarGrids">
    <Day>
        <xsl:value-of select="AvamarGridTime[@Day='Monday']/AvamarGrid" />
    </Day>
</xsl:template>

Added:

In order to create a separate Day element for each AvamarGrid within the selected AvamarGridTime, you can do:

<xsl:template match="/AvamarGrids">
    <xsl:for-each select="AvamarGridTime[@Day='Tuesday']/AvamarGrid">
        <Day>
            <xsl:value-of select="." />
        </Day>
    </xsl:for-each>
</xsl:template>

However, do note that the result is an XML fragment. If you want to produce a well-formed XML document, you must add a root element.

edited Feb 24, 2020 at 17:46

answered Feb 24, 2020 at 17:11

michael.hor257k

118k6 gold badges36 silver badges55 bronze badges

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

5 Comments

Anchal Sarraf Over a year ago

when I am using above XSLT for Tuesday, I am getting only first output: <?xml version="1.0" encoding="UTF-8"?><Day>ftc-opavautl961</Day> But I need all three grids name

michael.hor257k Over a year ago

What should the output look like in this case?

Anchal Sarraf Over a year ago

<Day>ftc-opavautl961</Day> <Day>ftc-opavbutl921</Day> <Day>ptc-opavautl981</Day>

Anchal Sarraf Over a year ago

Above should be the output for this: <AvamarGridTime Day="Tuesday"> <AvamarGrid>ftc-opavautl961</AvamarGrid> <AvamarGrid>ftc-opavbutl921</AvamarGrid> <AvamarGrid>ptc-opavautl981</AvamarGrid> </AvamarGridTime>

michael.hor257k Over a year ago

See the addition to my post.

Collectives™ on Stack Overflow

How to extract specific value from XML either using Xpath or XSLT

1 Answer 1

Added:

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Added:

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related