Hi All,

I have got a requirement. I got an xml file like this

<Players>
<player>
 <Name>Rakesh</Name>
</Player>
<player>
 <Name>Ashish</Name>
</Player>
</Players>

I have to show output like below
 Players: Rakesh,Ashish

Is there any aggregate function which will do this? Is there any other way of doing apart from looping through and concatenating the values with a script? Please help.

Rakesh

Well with XSLT 2.0 you can use
With XSLT 1.0 you need to use xsl:for-each or xsl:apply-templates to output each name and the comma for each Name but the last one.

--
  Martin Honnen
  Microsoft MVP - XML

In 2.0, use the string-join() function, or simply

<xsl:value-of select="//Name" separator=","/>

In 1.0 use

<xsl:for-each select="//Name">
  <xsl:value-of select="."/>
  <xsl:if test="position()!=last()">,</xsl:if>
</

Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer's Reference

Thanks for that. One silly question. how can we use 2.0 version if our xslt is of 1.0. is there any way to upgrade?

Rakesh

You need to run your stylesheet with an XSLT 2.0 processor like Saxon or Gestalt or Altova.
And you should use
to make full use of XSLT 2.0 features like the suggested xsl:value-of use.

--
  Martin Honnen
  Microsoft MVP - XML

Thanks martin for the response.