Hi all,

I would like to sort the element which has both alphabets and numbers.
How to sort the following elements based on Pin.

<PinNo><Pin>A17</Pin></PinNo>
<PinNo><Pin>A1</Pin></PinNo>
<PinNo><Pin>A3</Pin></PinNo>
<PinNo><Pin>A31</Pin></PinNo>

Note: Always the Pin starts with an alphabet..

Normal way of sorting gives me: A1, A17, A3, A31 which is wrong.. I need it like A1, A3, A17, A31

code:

<xsl:for-each select="PinNo">
  <xsl:sort select="Pin"/>
<xsl:value-of select="Pin"/>
</xsl:for-each>

Hope you will solve my problem

Regards,
Jack

Saxon has an option for this:

<xsl:sort select="Pin" collation="http://saxon.sf.net/collation?alphanumeric=yes"

Further info at
http://www.saxonica.com/documentatio...collation.html

If the alpha part of the sort key is always one character, you can do

<xsl:sort select="substring(Pin,1,1)" data-type="text"/>
<xsl:sort select="substring(Pin,2)" data-type="number"/>

If the alpha part is always [A-Z], you could try

<xsl:sort select="translate(Pin,'0123456789','')" data-type="text"/>
<xsl:sort select="translate(Pin,'ABCDE...','')" data-type="number"/>

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

Dear Mr.Kay,

Thanks a lot.. it did work.. Very very thankful to you..

Regards,
jack