'How to select only top level tags?

I`ve a xml file:

<response>
<ERROR_CODE>0</ERROR_CODE>
<result>
    <value>
        <Account>L01+00000F00</Account>
        <SecurCode>RU000A1017H9</SecurCode>
        <Accruedint>0.0000</Accruedint>
        <ComisClear>0.0000</ComisClear>
    </value>
    <value>
        <Account>1231+00000F00</Account>
        <SecurCode>RU000A1017H9</SecurCode>
        <Accruedint>0.12300</Accruedint>
        <ComisClear>0.012300</ComisClear>
    </value>
</result>

I wanna wrap all values deep value tag on <![CDATA]]> tag. Now i try to do that way:

<xsl:template match="/">
    <response>
        <xsl:apply-templates select="response"/>
    </response>
</xsl:template>

<xsl:template match="response">
    <xsl:for-each select="*">
        <xsl:element name="{local-name()}">
            <xsl:value-of select="substring(*,1,3)"/>
            <xsl:value-of select="current()"/>
        </xsl:element>
    </xsl:for-each>
    <xsl:apply-templates select="value"/>
</xsl:template>

<xsl:template match="value">
    <xsl:element name="value">
       <xsl:apply-templates select="*"/>
    </xsl:element>
</xsl:template>

<xsl:template match="*">
    <xsl:element name="{local-name()}">
        <xsl:value-of select="substring(*,1,3)"/>
        <xsl:text disable-output-escaping="yes">&lt;![CDATA[</xsl:text>
        <xsl:value-of select="current()"/>
        <xsl:text disable-output-escaping="yes">]]&gt;</xsl:text>
    </xsl:element>
</xsl:template>

Excepted XML:

<response>
<ERROR_CODE>0</ERROR_CODE>
<result>
    <value>
        <Account><![CDATA[L01+00000F00]]></Account>
        <SecurCode><![CDATA[RU000A1017H9]]></SecurCode>
        <Accruedint><![CDATA[0.0000]]></Accruedint>
        <ComisClear><![CDATA[0.0000]]></ComisClear>
    </value>
    <value>
        <Account><![CDATA[1231+00000F00]]></Account>
        <SecurCode><![CDATA[RU000A1017H9]]></SecurCode>
        <Accruedint><![CDATA[0.12300]]></Accruedint>
        <ComisClear><![CDATA[0.012300]]></ComisClear>
    </value>

Data in value tag always diferent (i`m generating custom fileds every time)

But i have a problem on <xsl:for-each select="*"> becouse it`s including ALL nodes, so how i can just foreach on top level tags??

xmlxpathxslt-1.0


Solution 1:[1]

<xsl:template match="node()|@*">
  <xsl:copy>
    <xsl:apply-templates select="node()"/>
  </xsl:copy>
</xsl:template>

<xsl:template match="value/*">
  <xsl:copy>
    <xsl:value-of select="substring(*,1,3)"/>
    <xsl:text disable-output-escaping="yes">&lt;![CDATA[</xsl:text>
    <xsl:value-of select="current()"/>
    <xsl:text disable-output-escaping="yes">]]&gt;</xsl:text>
  </xsl:copy>    
</xsl:template>

Solution 2:[2]

Please try the following solution.

It is using a so called Identity Transform pattern, and the cdata-section-elements attribute to enlist all desired elements for a CData section.

The cdata-section-elements attribute is a built-in feature of XSLT standard to add CData sections.

XSLT

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
   <xsl:output method="xml" encoding="utf-8" indent="yes" cdata-section-elements="Account SecurCode Accruedint ComisClear"/>
   <xsl:strip-space elements="*"/>

   <xsl:template match="@*|node()">
      <xsl:copy>
         <xsl:apply-templates select="@*|node()"/>
      </xsl:copy>
   </xsl:template>
</xsl:stylesheet>

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 user7333101
Solution 2

Related Questions