removing duplicate elements

[Vijay Chouhan]

Hi Ranchers,

I have some XML data of the following structure.

   
<cities>
<city>New Delhi</city>
<city>New York</city>
<city>Chicago</city>
<city>New York</city>
<city>London</city>
<city>New Delhi</city>
<city>New York</city>
</cities>

Now I need to process this data using XSL and ensure that the duplicate elements are output only once. Also the order of the elements should not be changed. The output for the above should look like.

    
<cities>
<city>New Delhi</city>
<city>New York</city>
<city>Chicago</city>
<city>London</city>
</cities>

Try as I hard I can, I am not able to make any headway. Will really appreciate any leads.

TIA

[Radha Voodi]

Hi,
Try this:

<xsl:template match="@*|node()">
<xsl:if test="not(node()) or not(preceding-sibling::node()[.=string(current()) and name()=name(current()])">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:if>
</xsl:template>

Thanks,
Radha

[Vijay Chouhan]

Hey thanks a ton Radha.. You've solved my problem.