XSLT:检查空元素和空元素的条件,然后只为其他元素赋值 [英] XSLT :Condition for check if null and empty element then only assign value to other element
问题描述
我们输入了 XML.因此,对于许多行项目(OrderLineID 元素),StockCode 元素为空.对于 XML 中的所有空 StockCode 元素,必须有 Comment 元素值.同样,对于所有这样的空 Comment 元素,必须存在 StockCode 值.
We have input XML.In that,StockCode element is empty for many line items (OrderLineID elements). For all empty StockCode element in XML there must be Comment element value. Similarly,For all such empty Comment elements there must be StockCode Value Exist.
注意:OrderDetail 在此处重复节点.
场景:
我们必须拆分 OrderDescription 字符串.这样它总是寻找空的 StockCode 元素.然后只将拆分字符串值分配给 Comment 元素.否则对于所有具有值的 StockCode 不应将拆分字符串分配给注释元素
We have to split OrderDescription string . such a way that it always look for empty StockCode element. then only Assign split string values to Comment elements. Otherwise for all StockCode having value should not assign split string to Comment Element
输入 XML :
<SalesOrders xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="SORTOIDOC.XSD">
<Orders>
<OrderHeader>
<Customer>000016</Customer>
<OrderDate>2016-04-19</OrderDate>
<SalesForceOrderNumber>ORD-411324</SalesForceOrderNumber>
</OrderHeader>
<OrderDetails>
<StockLine>
<StockCode>ABB-CDE-FGH-01</StockCode>
<OrderDescription>EDIORDER-SAVE COMMENTS
C3 Generic
LOC 0833
Expected arrival 01/07/2016
OTYPE NE
TRKPC 01 GM/00007643020008361321</OrderDescription>
<OrderLineID>OR-1561179</OrderLineID>
</StockLine>
<StockLine>
<StockCode>BCD-EFGH-01</StockCode>
<OrderLineID>OR-1561186</OrderLineID>
</Comment>
</StockLine>
<StockLine>
<StockCode></StockCode>
</Comment>
<OrderLineID>OR-1561180</OrderLineID>
</StockLine>
<StockLine>
<StockCode></StockCode>
</Comment>
<OrderLineID>OR-1561181</OrderLineID>
</StockLine>
<StockLine>
<StockCode></StockCode>
</Comment>
<OrderLineID>OR-1561182</OrderLineID>
</StockLine>
<StockLine>
<StockCode></StockCode>
</Comment>
<OrderLineID>OR-1561183</OrderLineID>
</StockLine>
<StockLine>
<StockCode></StockCode>
</Comment>
<OrderLineID>OR-1561184</OrderLineID>
</StockLine>
<StockLine>
<StockCode></StockCode>
</Comment>
<OrderLineID>OR-1561185</OrderLineID>
</StockLine>
</OrderDetails>
</Orders>
</SalesOrders>
用于转换的现有 XSLT:
XSLT2.0
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:strip-space elements="*"/>
<!-- identity transform -->
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="StockLine">
<xsl:variable name="i" select="position()" />
<xsl:copy>
<xsl:copy-of select="StockCode"/>
<Comment>
<xsl:value-of select="normalize-space(tokenize(../StockLine[1]/OrderDescription, '\n')[$i])"/>
</Comment>
<xsl:copy-of select="OrderLineID"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
预期输出值:
<SalesOrders xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="SORTOIDOC.XSD">
<Orders>
<OrderHeader>
<Customer>000016</Customer>
<OrderDate>2016-04-19</OrderDate>
<SalesForceOrderNumber>ORD-411324</SalesForceOrderNumber>
</OrderHeader>
<OrderDetails>
<StockLine>
<StockCode>ABB-CDE-FGH-01</StockCode>
</Comment>
<OrderDescription>EDIORDER-SAVE COMMENTS
C3 Generic
LOC 0833
Expected arrival 01/07/2016
OTYPE NE
TRKPC 01 GM/00007643020008361321</OrderDescription>
<OrderLineID>OR-1561179</OrderLineID>
</StockLine>
<StockLine>
<StockCode>BCD-EFGH-01</StockCode>
<OrderLineID>OR-1561186</OrderLineID>
</Comment>
</StockLine>
<StockLine>
<Comment>EDIORDER-SAVE COMMENTS</Comment>
</StockCode>
<OrderLineID>OR-1561180</OrderLineID>
</StockLine>
<StockLine>
<Comment>C3 Generic</Comment>
</StockCode>
<OrderLineID>OR-1561181</OrderLineID>
</StockLine>
<StockLine>
<Comment>LOC 0833</Comment>
</StockCode>
<OrderLineID>OR-1561182</OrderLineID>
</StockLine>
<StockLine>
<Comment>Expected arrival 01/07/2016</Comment>
</StockCode>
<OrderLineID>OR-1561183</OrderLineID>
</StockLine>
<StockLine>
<Comment> OTYPE NE</Comment>
</StockCode>
<OrderLineID>OR-1561184</OrderLineID>
</StockLine>
<StockLine>
<Comment>TRKPC 01 GM/00007643020008361321</Comment>
</StockCode>
<OrderLineID>OR-1561185</OrderLineID>
</StockLine>
</OrderDetails>
</Orders>
</SalesOrders>
推荐答案
这是我的建议标记一次并将值作为参数传递:
Here is my suggestion tokenizing once and passing on the value as a parameter:
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
exclude-result-prefixes="xs">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:strip-space elements="*"/>
<!-- identity transform -->
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="OrderDetails">
<xsl:copy>
<xsl:variable name="descriptions" as="xs:string*" select="tokenize(StockLine[1]/OrderDescription, '\n')"/>
<xsl:apply-templates>
<xsl:with-param name="descriptions" as="xs:string*" select="$descriptions" tunnel="yes"/>
</xsl:apply-templates>
</xsl:copy>
</xsl:template>
<xsl:template match="StockLine/StockCode[not(normalize-space())]">
<xsl:param name="descriptions" tunnel="yes"/>
<xsl:variable name="pos" as="xs:integer">
<xsl:number count="StockLine[StockCode[not(normalize-space())]]"/>
</xsl:variable>
<xsl:copy>
<xsl:value-of select="normalize-space($descriptions[$pos])"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
如果您想创建新的 Comment
元素而不是填充空的 StockCode
,请使用如下方法:
If you want to create new Comment
elements instead of populating the empty StockCode
then use an approach like this:
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
exclude-result-prefixes="xs">
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
<xsl:strip-space elements="*"/>
<!-- identity transform -->
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="OrderDetails">
<xsl:copy>
<xsl:variable name="descriptions" as="xs:string*" select="tokenize(StockLine[1]/OrderDescription, '\n')"/>
<xsl:apply-templates>
<xsl:with-param name="descriptions" as="xs:string*" select="$descriptions"/>
</xsl:apply-templates>
</xsl:copy>
</xsl:template>
<xsl:template match="StockLine[StockCode[not(normalize-space())]]">
<xsl:param name="descriptions"/>
<xsl:variable name="pos" as="xs:integer">
<xsl:number count="StockLine[StockCode[not(normalize-space())]]"/>
</xsl:variable>
<xsl:copy>
<xsl:copy-of select="*"/>
<Comment><xsl:value-of select="normalize-space($descriptions[$pos])"/></Comment>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
这篇关于XSLT:检查空元素和空元素的条件,然后只为其他元素赋值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!