在XSL转换中用顺序字母替换XML值 [英] Replace XML values with sequential alphabets in XSL transform

查看：92
本文介绍了在XSL转换中用顺序字母替换XML值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

给出输入的XML 

<FlightOptions> 
  <item> 
     <Fares> 
       <item> 
         <FareClass>T</FareClass> 
         <Fare>100</Fare> 
         <FareType>E</FareType> 
         <Seats>5</Seats> 
       </item> 
       <item> 
         <FareClass>Y</FareClass> 
         <Fare>200</Fare> 
         <FareType>E</FareType> 
         <Seats>10</Seats> 
       </item> 
       <item> 
         <FareClass>R</FareClass> 
         <Fare>250</Fare> 
         <FareType>E</FareType> 
         <Seats>20</Seats> 
       </item> 
       <item> 
         <FareClass>N</FareClass> 
         <Fare>100</Fare> 
         <FareType>F</FareType> 
         <Seats>5</Seats> 
       </item> 
       <item> 
         <FareClass>M</FareClass> 
         <Fare>200</Fare> 
         <FareType>F</FareType> 
         <Seats>50</Seats> 
       </item> 
       <item> 
         <FareClass>L</FareClass> 
         <Fare>300</Fare> 
         <FareType>F</FareType> 
         <Seats>20</Seats> 
       </item> 
       <item> 
        <FareClass>K</FareClass> 
        <Fare>400</Fare> 
        <FareType>F</FareType> 
        <Seats>5</Seats> 
       </item> 
       <item> 
        <FareClass>E</FareClass> 
        <Fare>500</Fare> 
        <FareType>F</FareType> 
        <Seats>9</Seats> 
       </item> 
     </Fares> 
     <Flight> 
         <FlightNumber>YY232</FlightNumber> 
         <Origin>JFK</Origin> 
         <Destination>LHR</Destination> 
         <DepTime>1300</DepTime> 
         <ArrTime>2000</ArrTime> 
     </Flight> 
    </item> 
</FlightOptions>

并应用XSL模板(感谢Tim C提供此功能！)-

and applying the XSL template (Thanks Tim C for providing this!) - 

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

   <xsl:template match="Fares"> 
      <xsl:copy> 
         <xsl:apply-templates select="item"> 
            <xsl:sort select="FareType"/> 
            <xsl:sort select="Fare"/> 
         </xsl:apply-templates> 
      </xsl:copy> 
   </xsl:template> 

   <xsl:template match="Fares/item"> 
      <xsl:if test="not(preceding-sibling::item[FareType=current()/FareType][Seats > 9])"> 
         <xsl:call-template name="identity"/> 
      </xsl:if> 
   </xsl:template> 

   <xsl:template match="Seats[. > 9]"> 
      <xsl:copy>9</xsl:copy> 
   </xsl:template> 

   <xsl:template match="@*|node()"> 
      <xsl:call-template name="identity"/> 
   </xsl:template> 

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

</xsl:stylesheet>

我们得到以下输出XML-

We get the following output XML -

<FlightOptions> 
  <item> 
     <Fares> 
       <item> 
         <FareClass>T</FareClass> 
         <Fare>100</Fare> 
         <FareType>E</FareType> 
         <Seats>5</Seats> 
       </item> 
       <item> 
         <FareClass>Y</FareClass> 
         <Fare>200</Fare> 
         <FareType>E</FareType> 
         <Seats>9</Seats> 
       </item> 
       <item> 
         <FareClass>R</FareClass> 
         <Fare>250</Fare> 
         <FareType>E</FareType> 
         <Seats>9</Seats> 
       </item> 
       <item> 
         <FareClass>N</FareClass> 
         <Fare>100</Fare> 
         <FareType>F</FareType> 
         <Seats>5</Seats> 
       </item> 
       <item> 
         <FareClass>M</FareClass> 
         <Fare>200</Fare> 
         <FareType>F</FareType> 
         <Seats>9</Seats> 
       </item> 
       <item> 
         <FareClass>L</FareClass> 
         <Fare>300</Fare> 
         <FareType>F</FareType> 
         <Seats>9</Seats> 
       </item> 
       <item> 
        <FareClass>K</FareClass> 
        <Fare>400</Fare> 
        <FareType>F</FareType> 
        <Seats>5</Seats> 
       </item> 
       <item> 
        <FareClass>E</FareClass> 
        <Fare>500</Fare> 
        <FareType>F</FareType> 
        <Seats>9</Seats> 
       </item> 
     </Fares> 
     <Flight> 
         <FlightNumber>YY232</FlightNumber> 
         <Origin>JFK</Origin> 
         <Destination>LHR</Destination> 
         <DepTime>1300</DepTime> 
         <ArrTime>2000</ArrTime> 
     </Flight> 
    </item> 
</FlightOptions>

我想对上述输出执行的操作是，按照选择每个项目的顺序，用字母顺序(A，B，C，D ...)替换FareClass标签.另外，我想保持G和Y FareClass不变. [如果您对XML/XSL有疑问，我会问#8074924，这是由Tim C解决的.]

What i'd like to do with the above output is to replace the FareClass tags with letters of the alphabet in sequence (A,B,C,D...) in the order each item gets selected. In addition, i'd like to leave the G and Y FareClass unchanged. [In case you have questions on the XML/XSL, I'd asked question #8074924 which was solved by Tim C.]

输出XML必须如下所示:

The output XML needs to look like:

<FlightOptions> 
  <item> 
     <Fares> 
       <item> 
         <FareClass>A</FareClass> 
         <Fare>100</Fare> 
         <FareType>E</FareType> 
         <Seats>5</Seats> 
       </item> 
       <item> 
         <FareClass>Y</FareClass> 
         <Fare>200</Fare> 
         <FareType>E</FareType> 
         <Seats>10</Seats> 
       </item> 
       <item> 
         <FareClass>B</FareClass> 
         <Fare>250</Fare> 
         <FareType>E</FareType> 
         <Seats>20</Seats> 
       </item> 
       <item> 
         <FareClass>N</FareClass> 
         <Fare>100</Fare> 
         <FareType>F</FareType> 
         <Seats>5</Seats> 
       </item> 
       <item> 
         <FareClass>C</FareClass> 
         <Fare>200</Fare> 
         <FareType>F</FareType> 
         <Seats>50</Seats> 
       </item> 
       <item> 
         <FareClass>D</FareClass> 
         <Fare>300</Fare> 
         <FareType>F</FareType> 
         <Seats>20</Seats> 
       </item> 
       <item> 
        <FareClass>E</FareClass> 
        <Fare>400</Fare> 
        <FareType>F</FareType> 
        <Seats>5</Seats> 
       </item> 
       <item> 
        <FareClass>F</FareClass> 
        <Fare>500</Fare> 
        <FareType>F</FareType> 
        <Seats>9</Seats> 
       </item> 
     </Fares> 
     <Flight> 
         <FlightNumber>YY232</FlightNumber> 
         <Origin>JFK</Origin> 
         <Destination>LHR</Destination> 
         <DepTime>1300</DepTime> 
         <ArrTime>2000</ArrTime> 
     </Flight> 
    </item> 
</FlightOptions>

推荐答案

如果我正确理解，则需要基于Tim解决方案的解决方案，但是在输出中，所有FareClass值都从A重新排序为Z输出文档顺序，但G和Y不变.

If I have understood correctly, you want a solution based off of Tim's solution, but in the output have all the FareClass values re-sequenced from A to Z in output document order, but with G and Y unchanged.

我会像这样使用管道方法.请注意，阶段1是直接从Tim复制的，只能通过添加mode属性来更改.

I would use a pipe-line method like so. Please note that phase-1 is copied directly from Tim, only changed by adding the mode attributes.

<xsl:stylesheet version="1.0"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:exslt="http://exslt.org/common"
  exclude-result-prefixes="xsl exslt"> 
<xsl:output omit-xml-declaration="yes" indent="yes" />
<xsl:strip-space elements="*" />

<xsl:variable name="phase-1-output">
  <xsl:apply-templates select="/" mode="phase-1" />
</xsl:variable>

<xsl:variable name="phase-2-output">
  <xsl:apply-templates select="exslt:node-set($phase-1-output)" mode="phase-2" />
</xsl:variable>


<xsl:template match="/">
  <xsl:copy-of select="$phase-2-output" />
</xsl:template>

<!-- ================ Phase One from Tim C ==============================-->   
   <xsl:template match="Fares" mode="phase-1"> 
      <xsl:copy> 
         <xsl:apply-templates select="item" mode="phase-1" > 
            <xsl:sort select="FareType"/> 
            <xsl:sort select="Fare"/> 
         </xsl:apply-templates> 
      </xsl:copy> 
   </xsl:template> 

   <xsl:template match="Fares/item" mode="phase-1"> 
      <xsl:if test="not(preceding-sibling::item[FareType=current()/FareType][Seats > 9])"> 
         <xsl:call-template name="identity-1" /> 
      </xsl:if> 
   </xsl:template> 

   <xsl:template match="Seats[. > 9]" mode="phase-1"> 
      <xsl:copy>9</xsl:copy> 
   </xsl:template> 

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


<!-- ================ Phase Two ============================================-->   

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

   <xsl:template match="FareClass[.!='G'][.!='Y']" mode="phase-2"> 
      <xsl:copy> 
        <xsl:variable name="raw-count">
         <xsl:number count="item[(FareClass!='G') and (FareClass!='Y')]" /> 
        </xsl:variable>
        <xsl:number value="$raw-count + not($raw-count &lt;  7)
                                      + not($raw-count &lt; 25)" format="A" />
      </xsl:copy> 
   </xsl:template> 


</xsl:stylesheet>

...使用来自原始编辑的样本输入 ，产生输出...

...using the sample input from the original edit, yields output...

<FlightOptions>
  <item>
    <Fares>
      <item>
        <FareClass>A</FareClass>
        <Fare>100</Fare>
        <FareType>E</FareType>
        <Seats>5</Seats>
      </item>
      <item>
        <FareClass>B</FareClass>
        <Fare>200</Fare>
        <FareType>E</FareType>
        <Seats>10</Seats>
      </item>
      <item>
        <FareClass>C</FareClass>
        <Fare>250</Fare>
        <FareType>E</FareType>
        <Seats>20</Seats>
      </item>
      <item>
        <FareClass>D</FareClass>
        <Fare>100</Fare>
        <FareType>F</FareType>
        <Seats>5</Seats>
      </item>
      <item>
        <FareClass>E</FareClass>
        <Fare>200</Fare>
        <FareType>F</FareType>
        <Seats>50</Seats>
      </item>
      <item>
        <FareClass>F</FareClass>
        <Fare>300</Fare>
        <FareType>F</FareType>
        <Seats>20</Seats>
      </item>
    </Fares>
    <Flight>
      <FlightNumber>YY232</FlightNumber>
      <Origin>JFK</Origin>
      <Destination>LHR</Destination>
      <DepTime>1300</DepTime>
      <ArrTime>2000</ArrTime>
    </Flight>
  </item>
</FlightOptions>

更新

感谢Surge提供了新的改进用例.使用我的解决方案，更新后的测试用例的输出是...

UPDATE

Thanks Surge for the new and improved use case. The output for the updated test case, using my solution is ...

<FlightOptions>
  <item>
    <Fares>
      <item>
        <FareClass>A</FareClass>
        <Fare>100</Fare>
        <FareType>E</FareType>
        <Seats>5</Seats>
      </item>
      <item>
        <FareClass>Y</FareClass>
        <Fare>200</Fare>
        <FareType>E</FareType>
        <Seats>9</Seats>
      </item>
      <item>
        <FareClass>B</FareClass>
        <Fare>250</Fare>
        <FareType>E</FareType>
        <Seats>9</Seats>
      </item>
      <item>
        <FareClass>C</FareClass>
        <Fare>100</Fare>
        <FareType>F</FareType>
        <Seats>5</Seats>
      </item>
      <item>
        <FareClass>D</FareClass>
        <Fare>200</Fare>
        <FareType>F</FareType>
        <Seats>9</Seats>
      </item>
      <item>
        <FareClass>E</FareClass>
        <Fare>300</Fare>
        <FareType>F</FareType>
        <Seats>9</Seats>
      </item>
      <item>
        <FareClass>F</FareClass>
        <Fare>400</Fare>
        <FareType>F</FareType>
        <Seats>5</Seats>
      </item>
      <item>
        <FareClass>H</FareClass>
        <Fare>500</Fare>
        <FareType>F</FareType>
        <Seats>9</Seats>
      </item>
    </Fares>
    <Flight>
      <FlightNumber>YY232</FlightNumber>
      <Origin>JFK</Origin>
      <Destination>LHR</Destination>
      <DepTime>1300</DepTime>
      <ArrTime>2000</ArrTime>
    </Flight>
  </item>
</FlightOptions>

这与您声明的预期输出略有不同，但是我相信可以通过您犯了一个错误的事实来解释这种差异(请参阅FareClass N).通过检查，我认为这是通过的结果.

This is slightly different from your stated expected output, but I believe the difference can be explained by the fact that you made an error (See FareClass N). By inspection, I deem this is a PASS result.

糟糕.刚注意到二进制错误并已纠正它们.原始的错误模板是...

Oops. Just noticed twos errors and have corrected them. The original erroneous template was...

<xsl:variable name="phase-2-output">
  <xsl:apply-templates select="/" mode="phase-2" />
</xsl:variable>

和

 <xsl:number count="item" />

正确的代码应该是...

The correct code should be...

<xsl:variable name="phase-2-output">
  <xsl:apply-templates select="exslt:node-set($phase-1-output)" mode="phase-2" />
</xsl:variable>

和

 <xsl:number count="item[(FareClass!='G') and (FareClass!='Y')]" />

这篇关于在XSL转换中用顺序字母替换XML值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆