[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Muenchian Sorting with Substrings and Translated S
> -----Original Message----- > From: Brook Ellingwood > > My first challenge is that I want to change the ProductFamily sort so that > it groups first by the alpha characters, and then by the numerical ones. I > seems that I need to turn the value of ProductFamily into a > string so I can sort on substrings but that can't work. > How about something like: <xsl:variable name="$numeric" select="'1234567890'" /> <xsl:variable name="$alpha" select="'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'" /> ... <xsl:apply-templates select="Product"> <xsl:sort select="concat( translate(ProductFamily,$numeric,''),translate(ProductFamily,$alpha,''))" /> </xsl:apply-templates> So you sort on a concatenation of all the ProductFamily's alpha characters and its numerics, in the right order for your convenience. (You only still need to deal with the " entities, and the decimal-points...) Hope this gives you an idea! Cheers, Andreas XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|