Search code examples
htmlxmlxml-parsingxslt-2.0saxon

Parsing a variable containing xml string in xslt

I am trying to form an html template with xslt where I need to parse values from a variable containing xml string. But not being able to do so. If I try to print the variable it's showing the whole xml string with < and > being replaced with &lt; and &gt; respectively , but is not being parsed with xpath when tried.

Below is my xml string looks like which I stored in a variable named "SpecificOrderDetails". If I try the expression

<xsl:value-of select="$SpecificOrderDetails/SPECIFICORDERDETAILS/text()"/>

it gives me null value as output

<SPECIFICORDERDETAILS><ORDERROW><CATEGORY>1</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>Hard-wired Return Path</COMPONENTNAME><COMPONENTID>101401</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>1</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>Platinum Included FBO Movies</COMPONENTNAME><COMPONENTID>101500</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>1</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>iQ Discount</COMPONENTNAME><COMPONENTID>101501</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>1</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>Primary Discounts</COMPONENTNAME><COMPONENTID>101504</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>1</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>03 Foxtel iQ</COMPONENTNAME><COMPONENTID>101601</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>1</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>TV - 24 Month Contract</COMPONENTNAME><COMPONENTID>101714</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>1</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>Standard Install - No Offer</COMPONENTNAME><COMPONENTID>101723</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>1</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>My Platinum Eligibility</COMPONENTNAME><COMPONENTID>101900</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>1</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>Commitment Eligibility</COMPONENTNAME><COMPONENTID>101913</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>1</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>Platinum Channels</COMPONENTNAME><COMPONENTID>990015</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>4</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>Smartcard</COMPONENTNAME><COMPONENTID>101</COMPONENTID></ORDERROW><ORDERROW><CATEGORY>4</CATEGORY><ACTION>0</ACTION><COMPONENTNAME>iQ PDR - Satellite</COMPONENTNAME><COMPONENTID>201</COMPONENTID></ORDERROW></SPECIFICORDERDETAILS>

If I try to print the variable it shows the whole xml string as below 

<tr>
   <td class="headingSubText" style="font-size:13pt; padding:10px 0px 0px 15px">&lt;SPECIFICORDERDETAILS&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;1&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;Hard-wired Return Path&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;101401&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;1&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;Platinum
      Included FBO Movies&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;101500&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;1&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;iQ
      Discount&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;101501&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;1&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;Primary
      Discounts&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;101504&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;1&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;03
      Foxtel iQ&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;101601&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;1&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;TV
      - 24 Month Contract&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;101714&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;1&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;Standard
      Install - No Offer&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;101723&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;1&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;My
      Platinum Eligibility&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;101900&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;1&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;Commitment
      Eligibility&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;101913&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;1&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;Platinum
      Channels&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;990015&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;4&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;Smartcard&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;101&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;ORDERROW&gt;&lt;CATEGORY&gt;4&lt;/CATEGORY&gt;&lt;ACTION&gt;0&lt;/ACTION&gt;&lt;COMPONENTNAME&gt;iQ
      PDR - Satellite&lt;/COMPONENTNAME&gt;&lt;COMPONENTID&gt;201&lt;/COMPONENTID&gt;&lt;/ORDERROW&gt;&lt;/SPECIFICORDERDETAILS&gt;
   </td>
</tr>

Please help someone on how to parse the variable inside xslt . Let know if I was not clear enough. This would my first question ever asked on stackoverflow.

Solution

  • Got it working !

    Used xmlns:saxon="http://saxon.sf.net/" extension for xslt2.0 and it works perfectly to parse the xml string in the variable like below.

    <xsl:value-of select="saxon:parse($SpecificOrderDetails)/SPECIFICORDERDETAILS/ORDERROW[ACTION ='0']"/>

    Thanks everyone for helping!