如何使用 XSLT 删除重复节点? [英] How to remove duplicate nodes using XSLT?
本文介绍了如何使用 XSLT 删除重复节点?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如果系统发现重复,它应该完全消除两个节点.我的原始 xml 为:
If system finds a duplicate , it should eliminate both nodes altogether. I have original xml as:
<?xml version="1.0" encoding="utf-8"?>
<RESPONSE>
<RECORD>
<COUNTRY_ID>2111</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>2121</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>2211</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>2221</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3111</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3121</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3211</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3221</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>2111</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>2121</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>2211</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>2221</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>2311</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>2321</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3111</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3121</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3211</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3221</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3311</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3321</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4111</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4121</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4211</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4221</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4311</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4321</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
</RESPONSE>
并且所需的输出应该在下面:
and the desired output should be below:
<?xml version="1.0" encoding="utf-8"?>
<RESPONSE>
<RECORD>
<COUNTRY_ID>2311</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>2321</COUNTRY_ID>
<CITY id="2:">0</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3311</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>3321</COUNTRY_ID>
<CITY id="3:">30</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4111</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4121</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="1:14404388">LA11CFTXX</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4211</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4221</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="2:14048042">LAZ1129YY</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4311</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="1:">1</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
<RECORD>
<COUNTRY_ID>4321</COUNTRY_ID>
<CITY id="4:">100</CITY>
<LOCATION id="3:14048629">LAZ11B91AA</LOCATION>
<REPID id="2:">2</REPID>
<FLIGHTID id="1:1091513">ALK</FLIGHTID>
</RECORD>
</RESPONSE>
我们可以写一个 xsl 来做到这一点吗?
can we able to write an xsl to do this?
谢谢
推荐答案
试试这个:
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<xsl:apply-templates select="RESPONSE"/>
</xsl:template>
<xsl:template match="RESPONSE">
<RESPONSE>
<xsl:apply-templates select="RECORD"/>
</RESPONSE>
</xsl:template>
<xsl:template match="RECORD">
<xsl:variable name="this" select="."/>
<xsl:variable name="country" select="COUNTRY_ID/text()"/>
<xsl:if test="not(../RECORD[COUNTRY_ID/text() = $country and generate-id($this) != generate-id(.)])">
<xsl:copy-of select="."/>
</xsl:if>
</xsl:template>
</xsl:stylesheet>
这一切都假设当您说重复"时,您的意思是 COUNTRY_ID 具有相同的内容.我的 XSLT 似乎生成了您想要的输出.
This is all assuming that when you say "duplicate" you mean that COUNTRY_ID has the same content. My XSLT appears to generate your desired output.
这篇关于如何使用 XSLT 删除重复节点?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文