使用XSLT识别并消除XML中的重复项


张三岁
2025-03-04 04:01:41 (5天前)


=“country =‘Virgin Islands,U.S。’”> VI< / xsl:when>
< xsl:when test =“country =‘Wallis and Futuna’”> WF< / xsl:when>
< xsl:when test =“country =‘Western

撒哈拉
</跨度>
’“&gt; EH&lt; / xsl:当

2 条回复
  1. 0# Fire ming | 2019-08-31 10-32



    在xslt 2.0中你可以做到这一点的一种方法是将你的国家名称分解为代码映射到变量,用它来创建一个返回给定国家名称的代码的函数,然后在group-by子句中使用该函数xsl:for-each-group,按代码分组 - 因为它们是分组键 - 按定义是唯一的:




    1. <xsl:stylesheet version=”2.0”
      xmlns:xsl=http://www.w3.org/1999/XSL/Transform
      xmlns:xs=http://www.w3.org/2001/XMLSchema

    2.             xmlns:set="http://exslt.org/sets"
    3.             xmlns:w="whatever"
    4.             exclude-result-prefixes="xsl xs set w">
    5. <xsl:output method="xml"
    6.             omit-xml-declaration="yes"
    7.             indent="yes"/>
    8. <xsl:variable name="countryCodes">
    9.     <country name="Afghanistan" code="AF"/>
    10.     <country name="?land Islands" code="AX"/>
    11.     <country name="Albania" code="AL"/>
    12.     <country name="Algeria" code="DZ"/>
    13.     <country name="American Samoa" code="AS"/>
    14.     <country name="Andorra" code="AD"/>
    15.     <country name="Angola" code="AO"/>
    16.     <country name="Anguilla" code="AI"/>
    17.     <country name="Antarctica" code="AQ"/>
    18.     <country name="Antigua and Barbuda" code="AG"/>
    19.     <country name="Argentina" code="AR"/>
    20.     <country name="Armenia" code="AM"/>
    21.     <country name="Aruba" code="AW"/>
    22.     <country name="Australia" code="AU"/>
    23.     <country name="Austria" code="AT"/>
    24.     <country name="Azerbaijan" code="AZ"/>
    25.     <country name="Bahamas" code="BS"/>
    26.     <country name="Bahrain" code="BH"/>
    27.     <country name="Bangladesh" code="BD"/>
    28.     <country name="Barbados" code="BB"/>
    29.     <country name="Belarus" code="BY"/>
    30.     <country name="Belgium" code="BE"/>
    31.     <country name="Belize" code="BZ"/>
    32.     <country name="Benin" code="BJ"/>
    33.     <country name="Bermuda" code="BM"/>
    34.     <country name="Bhutan" code="BT"/>
    35.     <country name="Bolivia, Plurinational State of" code="BO"/>
    36.     <country name="Bonaire, Sint Eustatius and Saba" code="BQ"/>
    37.     <country name="Bosnia and Herzegovina" code="BA"/>
    38.     <country name="Botswana" code="BW"/>
    39.     <country name="Bouvet Island" code="BV"/>
    40.     <country name="Brazil" code="BR"/>
    41.     <country name="British Indian Ocean Territory" code="IO"/>
    42.     <country name="Brunei Darussalam" code="BN"/>
    43.     <country name="Bulgaria" code="BG"/>
    44.     <country name="Burkina Faso" code="BF"/>
    45.     <country name="Burundi" code="BI"/>
    46.     <country name="Cambodia" code="KH"/>
    47.     <country name="Cameroon" code="CM"/>
    48.     <country name="Canada" code="CA"/>
    49.     <country name="Cape Verde" code="CV"/>
    50.     <country name="Cayman Islands" code="KY"/>
    51.     <country name="Central African Republic" code="CF"/>
    52.     <country name="Chad" code="TD"/>
    53.     <country name="Chile" code="CL"/>
    54.     <country name="China" code="CN"/>
    55.     <country name="Christmas Island" code="CX"/>
    56.     <country name="Cocos (Keeling) Islands" code="CC"/>
    57.     <country name="Colombia" code="CO"/>
    58.     <country name="Comoros" code="KM"/>
    59.     <country name="Congo" code="CG"/>
    60.     <country name="Congo, the Democratic Republic of the" code="CD"/>
    61.     <country name="Cook Islands" code="CK"/>
    62.     <country name="Costa Rica" code="CR"/>
    63.     <country name="C?te d Ivoire" code="CI"/>
    64.     <country name="Croatia" code="HR"/>
    65.     <country name="Cuba" code="CU"/>
    66.     <country name="Cura?ao" code="CW"/>
    67.     <country name="Cyprus" code="CY"/>
    68.     <country name="Czech Republic" code="CZ"/>
    69.     <country name="Denmark" code="DK"/>
    70.     <country name="Djibouti" code="DJ"/>
    71.     <country name="Dominica" code="DM"/>
    72.     <country name="Dominican Republic" code="DO"/>
    73.     <country name="Ecuador" code="EC"/>
    74.     <country name="Egypt" code="EG"/>
    75.     <country name="El Salvador" code="SV"/>
    76.     <country name="Equatorial Guinea" code="GQ"/>
    77.     <country name="Eritrea" code="ER"/>
    78.     <country name="Estonia" code="EE"/>
    79.     <country name="Ethiopia" code="ET"/>
    80.     <country name="Falkland Islands (Malvinas)" code="FK"/>
    81.     <country name="Faroe Islands" code="FO"/>
    82.     <country name="Fiji" code="FJ"/>
    83.     <country name="Finland" code="FI"/>
    84.     <country name="France" code="FR"/>
    85.     <country name="French Guiana" code="GF"/>
    86.     <country name="French Polynesia" code="PF"/>
    87.     <country name="French Southern Territories" code="TF"/>
    88.     <country name="Gabon" code="GA"/>
    89.     <country name="Gambia" code="GM"/>
    90.     <country name="Georgia" code="GE"/>
    91.     <country name="Germany" code="DE"/>
    92.     <country name="Ghana" code="GH"/>
    93.     <country name="Gibraltar" code="GI"/>
    94.     <country name="Greece" code="GR"/>
    95.     <country name="Greenland" code="GL"/>
    96.     <country name="Grenada" code="GD"/>
    97.     <country name="Guadeloupe" code="GP"/>
    98.     <country name="Guam" code="GU"/>
    99.     <country name="Guatemala" code="GT"/>
    100.     <country name="Guernsey" code="GG"/>
    101.     <country name="Guinea" code="GN"/>
    102.     <country name="Guinea-Bissau" code="GW"/>
    103.     <country name="Guyana" code="GY"/>
    104.     <country name="Haiti" code="HT"/>
    105.     <country name="Heard Island and McDonald Islands" code="HM"/>
    106.     <country name="Holy See (Vatican City State)" code="VA"/>
    107.     <country name="Honduras" code="HN"/>
    108.     <country name="Hong Kong" code="HK"/>
    109.     <country name="Hungary" code="HU"/>
    110.     <country name="Iceland" code="IS"/>
    111.     <country name="India" code="IN"/>
    112.     <country name="Indonesia" code="ID"/>
    113.     <country name="Iran, Islamic Republic of" code="IR"/>
    114.     <country name="Iran" code="IR"/>
    115.     <country name="Iraq" code="IQ"/>
    116.     <country name="Ireland" code="IE"/>
    117.     <country name="Isle of Man" code="IM"/>
    118.     <country name="Israel" code="IL"/>
    119.     <country name="Italy" code="IT"/>
    120.     <country name="Jamaica" code="JM"/>
    121.     <country name="Japan" code="JP"/>
    122.     <country name="Jersey" code="JE"/>
    123.     <country name="Jordan" code="JO"/>
    124.     <country name="Kazakhstan" code="KZ"/>
    125.     <country name="Kenya" code="KE"/>
    126.     <country name="Kiribati" code="KI"/>
    127.     <country name="Korea, Democratic Peoples Republic of" code="KP"/>
    128.     <country name="Korea, Republic of" code="KR"/>
    129.     <country name="Kuwait" code="KW"/>
    130.     <country name="Kyrgyzstan" code="KG"/>
    131.     <country name="Lao Peoples Democratic Republic" code="LA"/>
    132.     <country name="Latvia" code="LV"/>
    133.     <country name="Lebanon" code="LB"/>
    134.     <country name="Lesotho" code="LS"/>
    135.     <country name="Liberia" code="LR"/>
    136.     <country name="Libya" code="LY"/>
    137.     <country name="Liechtenstein" code="LI"/>
    138.     <country name="Lithuania" code="LT"/>
    139.     <country name="Luxembourg" code="LU"/>
    140.     <country name="Macao" code="MO"/>
    141.     <country name="Macedonia, the Former Yugoslav Republic of" code="MK"/>
    142.     <country name="Madagascar" code="MG"/>
    143.     <country name="Malawi" code="MW"/>
    144.     <country name="Malaysia" code="MY"/>
    145.     <country name="Maldives" code="MV"/>
    146.     <country name="Mali" code="ML"/>
    147.     <country name="Malta" code="MT"/>
    148.     <country name="Marshall Islands" code="MH"/>
    149.     <country name="Martinique" code="MQ"/>
    150.     <country name="Mauritania" code="MR"/>
    151.     <country name="Mauritius" code="MU"/>
    152.     <country name="Mayotte" code="YT"/>
    153.     <country name="Mexico" code="MX"/>
    154.     <country name="Micronesia, Federated States of" code="FM"/>
    155.     <country name="Moldova, Republic of" code="MD"/>
    156.     <country name="Monaco" code="MC"/>
    157.     <country name="Mongolia" code="MN"/>
    158.     <country name="Montenegro" code="ME"/>
    159.     <country name="Montserrat" code="MS"/>
    160.     <country name="Morocco" code="MA"/>
    161.     <country name="Mozambique" code="MZ"/>
    162.     <country name="Myanmar" code="MM"/>
    163.     <country name="Namibia" code="NA"/>
    164.     <country name="Nauru" code="NR"/>
    165.     <country name="Nepal" code="NP"/>
    166.     <country name="Netherlands" code="NL"/>
    167.     <country name="New Caledonia" code="NC"/>
    168.     <country name="New Zealand" code="NZ"/>
    169.     <country name="Nicaragua" code="NI"/>
    170.     <country name="Niger" code="NE"/>
    171.     <country name="Nigeria" code="NG"/>
    172.     <country name="Niue" code="NU"/>
    173.     <country name="Norfolk Island" code="NF"/>
    174.     <country name="Northern Mariana Islands" code="MP"/>
    175.     <country name="Norway" code="NO"/>
    176.     <country name="Oman" code="OM"/>
    177.     <country name="Pakistan" code="PK"/>
    178.     <country name="Palau" code="PW"/>
    179.     <country name="Palestine, State of" code="PS"/>
    180.     <country name="Palestinian" code="PS"/>
    181.     <country name="Panama" code="PA"/>
    182.     <country name="Papua New Guinea" code="PG"/>
    183.     <country name="Paraguay" code="PY"/>
    184.     <country name="Peru" code="PE"/>
    185.     <country name="Philippines" code="PH"/>
    186.     <country name="Pitcairn" code="PN"/>
    187.     <country name="Poland" code="PL"/>
    188.     <country name="Portugal" code="PT"/>
    189.     <country name="Puerto Rico" code="PR"/>
    190.     <country name="Qatar" code="QA"/>
    191.     <country name="R��union" code="RE"/>
    192.     <country name="Romania" code="RO"/>
    193.     <country name="Russia" code="RU"/>
    194.     <country name="Rwanda" code="RW"/>
    195.     <country name="Saint Barth��lemy" code="BL"/>
    196.     <country name="Saint Helena, Ascension and Tristan da Cunha" code="SH"/>
    197.     <country name="Saint Kitts and Nevis" code="KN"/>
    198.     <country name="Saint Lucia" code="LC"/>
    199.     <country name="Saint Martin (French part)" code="MF"/>
    200.     <country name="Saint Pierre and Miquelon" code="PM"/>
    201.     <country name="Saint Vincent and the Grenadines" code="VC"/>
    202.     <country name="Samoa" code="WS"/>
    203.     <country name="San Marino" code="SM"/>
    204.     <country name="Sao Tome and Principe" code="ST"/>
    205.     <country name="Saudi Arabia" code="SA"/>
    206.     <country name="Senegal" code="SN"/>
    207.     <country name="Serbia" code="RS"/>
    208.     <country name="Seychelles" code="SC"/>
    209.     <country name="Sierra Leone" code="SL"/>
    210.     <country name="Singapore" code="SG"/>
    211.     <country name="Sint Maarten (Dutch part)" code="SX"/>
    212.     <country name="Slovakia" code="SK"/>
    213.     <country name="Slovenia" code="SI"/>
    214.     <country name="Solomon Islands" code="SB"/>
    215.     <country name="Somalia" code="SO"/>
    216.     <country name="South Africa" code="ZA"/>
    217.     <country name="South Georgia and the South Sandwich Islands" code="GS"/>
    218.     <country name="South Sudan" code="SS"/>
    219.     <country name="Spain" code="ES"/>
    220.     <country name="Sri Lanka" code="LK"/>
    221.     <country name="Sudan" code="SD"/>
    222.     <country name="Suriname" code="SR"/>
    223.     <country name="Svalbard and Jan Mayen" code="SJ"/>
    224.     <country name="Swaziland" code="SZ"/>
    225.     <country name="Sweden" code="SE"/>
    226.     <country name="Switzerland" code="CH"/>
    227.     <country name="Syrian Arab Republic" code="SY"/>
    228.     <country name="Taiwan, Province of China" code="TW"/>
    229.     <country name="Tajikistan" code="TJ"/>
    230.     <country name="Tanzania, United Republic of" code="TZ"/>
    231.     <country name="Thailand" code="TH"/>
    232.     <country name="Timor-Leste" code="TL"/>
    233.     <country name="Togo" code="TG"/>
    234.     <country name="Tokelau" code="TK"/>
    235.     <country name="Tonga" code="TO"/>
    236.     <country name="Trinidad and Tobago" code="TT"/>
    237.     <country name="Tunisia" code="TN"/>
    238.     <country name="Turkey" code="TR"/>
    239.     <country name="Turkmenistan" code="TM"/>
    240.     <country name="Turks and Caicos Islands" code="TC"/>
    241.     <country name="Tuvalu" code="TV"/>
    242.     <country name="Uganda" code="UG"/>
    243.     <country name="Ukraine" code="UA"/>
    244.     <country name="United Arab Emirates" code="AE"/>
    245.     <country name="United Kingdom" code="GB"/>
    246.     <country name="United States" code="US"/>
    247.     <country name="United States Minor Outlying Islands" code="UM"/>
    248.     <country name="Uruguay" code="UY"/>
    249.     <country name="Uzbekistan" code="UZ"/>
    250.     <country name="Vanuatu" code="VU"/>
    251.     <country name="Venezuela. Bolivarian Republic of" code="VE"/>
    252.     <country name="Viet Nam" code="VN"/>
    253.     <country name="Virgin Islands, British" code="VG"/>
    254.     <country name="Virgin Islands, U.S." code="VI"/>
    255.     <country name="Wallis and Futuna" code="WF"/>
    256.     <country name="Western Sahara" code="EH"/>
    257.     <country name="Yemen" code="YE"/>
    258.     <country name="Zambia" code="ZM"/>
    259.     <country name="Zimbabwe" code="ZW"/>
    260. </xsl:variable>
    261. <xsl:function name="w:country-code">
    262.     <xsl:param name="name"/>
    263.     <xsl:variable name="countryCode" select="$countryCodes/*[@name = $name][1]/@code"/>
    264.     <xsl:value-of select="if ($countryCode) then $countryCode else 'CU'"/>
    265. </xsl:function>
    266. <xsl:template match="/">
    267.     <xsl:for-each-group select="addressList/address" group-by="w:country-code(country)">
    268.         <Country>
    269.             <CountryCode>
    270.                 <xsl:value-of select="current-grouping-key()"/>
    271.             </CountryCode>
    272.             <CountryTypeCode>COUNTRY_OF_REGISTRATION</CountryTypeCode>
    273.         </Country>
    274.     </xsl:for-each-group>
    275. </xsl:template>
    276. </code>

登录 后才能参与评论