How to get distinct values?

lina1821 · September 30th, 2013, 07:06 AM

Hello All!

I am have some XML.

Code:

<row>
  <Systems>
    <System>AAA, BBB, AAA, CCC, AAA</System>
  </Systems>
</row>

<row>
  <Systems>
    <System>AAA, CCC</System>
  </Systems>
</row>

<row>
  <Systems>
    <System>EEE, DDD, AAA</System>
  </Systems>
</row>

My xml output should look like that.

Code:

<row>
  <Systems>
    <System>AAA</System>
    <System>BBB</System>
    <System>CCC</System>
    <System>EEE</System>
    <System>DDD</System>
  </Systems>
</row>

How I can perform this conversion using XSLT 1.0?

Please help me!!!

Martin Honnen · September 30th, 2013, 07:12 AM

If you really need to use XSLT 1.0 then tell us which XSLT 1.0 processor you use and whether it supports EXSLT like http://www.exslt.org/str/functions/split/index.html.

lina1821 · September 30th, 2013, 07:31 AM

Quote:

Originally Posted by Martin Honnen

If you really need to use XSLT 1.0 then tell us which XSLT 1.0 processor you use and whether it supports EXSLT like http://www.exslt.org/str/functions/split/index.html.

I use XSLT 1.0 processor Saxon 6.5.5. it supports EXSLT.

Martin Honnen · October 1st, 2013, 05:27 AM

If you use Saxon 6 which is an XSLT 1.0 processor implemented in Java why can't you simply switch to Saxon 9, an XSLT 2.0 processor also implemented in Java?
That way you could use XSLT 2.0 and all you need is

Code:

<xsl:template match="/">
  <row>
     <Systems>
        <for-each select="distinct-values(row/Systems/System/tokenize(., ','))">
           <System><xsl:value-of select="."/></System>
        <for-each>
     </Systems>
  </row>
</xsl:template>