Question

我也有类似的XML 来自于一些硬件:

<invoice>
  <field name="item">Item 1;Item 2;Item 3</field>
  <field name="price">32.0;192.2;12.0</field>
  <field name="quantity">1;4;2</field>
</invoice>

我需要转换类似这个:

<invoice>
  <item>
    <desc>Item 1</desc>
    <price>32.0</price>
    <quantity>1</quantity>
  </item>
  <item>
    <desc>Item 1</desc>
    <price>192.0</price>
    <quantity>4</quantity>
  </item>
  <item>
    <desc>Item 3</desc>
    <price>12.0</price>
    <quantity>2</quantity>
  </item>     
</invoice>

此时,我尝试了斯特勒:tokenize (),但主要问题是构建一个简单的循环。我对XSLT的了解非常基本,我的工作进展就非常深入:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0" xmlns:str="http://exslt.org/strings">
<xsl:output method="xml" indent="yes" version="1.0" encoding="UTF-8" omit-xml-declaration="yes" />
<xsl:template match="inovice">
    <xsl:param name="separator" select=" ; "/>
    <xsl:param name="desc" select="str:tokenize(field[@name= item ],$separator)"/>
    <xsl:param name="price" select="str:tokenize(field[@name= price ],$separator)"/>
    <xsl:param name="quantity" select="str:tokenize(field[@name= quantity ],$separator)"/>
    <xsl:param name="count" select="count($desc)"/>
    <!-- some loop goes here -->
</xsl:template>
</xsl:stylesheet>

Answer 1

一个简单的 XSLT 2. 0 样式表, 对所有项目进行循环, 根据当前位置选择相应的价格/数量, 可以像这样看 :

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="xml" indent="yes"/>

  <xsl:template match="invoice">
    <xsl:variable name="fields" select="field"/>
    <invoice>
      <xsl:for-each select="tokenize(field[@name= item ],  ; )">
        <xsl:variable name="pos" select="position()"/>
        <item>
          <desc>
            <xsl:value-of select="."/>
          </desc>
          <price>
            <xsl:value-of select="tokenize($fields[@name= price ],  ; )[position()=$pos]"/>
          </price>
          <quantity>
            <xsl:value-of select="tokenize($fields[@name= quantity ],  ; )[position()=$pos]"/>
          </quantity>          
        </item>
      </xsl:for-each>
    </invoice>
  </xsl:template>
</xsl:stylesheet>

如果您想要使用 XSLT 1.0 与 EXSLT 扩展模块 < em>strings 一起使用, 样式表必须只稍稍修改 :

<xsl:stylesheet version="1.0" 
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:str="http://exslt.org/strings"
  extension-element-prefixes="str">
  <xsl:output method="xml" indent="yes"/>

  <xsl:template match="invoice">
    <xsl:variable name="fields" select="field"/>
    <invoice>
      <xsl:for-each select="str:tokenize(field[@name= item ],  ; )">
        <xsl:variable name="pos" select="position()"/>
        <item>
          <desc>
            <xsl:value-of select="."/>
          </desc>
          <price>
            <xsl:value-of select="str:tokenize($fields[@name= price ],  ; )[position()=$pos]"/>
          </price>
          <quantity>
            <xsl:value-of select="str:tokenize($fields[@name= quantity ],  ; )[position()=$pos]"/>
          </quantity>          
        </item>
      </xsl:for-each>
    </invoice>
  </xsl:template>
</xsl:stylesheet>

友情链接