xsl-list
[Top] [All Lists]

Re: a sorting conundrum

2005-03-03 12:47:56
On Fri, 4 Mar 2005 06:24:29 +1100, Dimitre Novatchev
<dnovatchev(_at_)gmail(_dot_)com> wrote:
Use the following sorting key:

substring(translate(., ' ', ''),
                string-length(substring-before(.,' '))  + 1
                )

This calculates the index of the first space, then removes the
space(s) from the string, then uses what follows the space as the
sorting key.

Seems to be more logical than any hack. Tested.


If we want to have a more efficient variant of the above, which avoids
the translate(),
(and we assume an intelligent optimizer),

then the following should be much more efficient:


substring(., 
                  string-length(substring-before(.,' ')) 
                + 
                  (string-length(substring-before(.,' ')) > 0)
                 )


Cheers,
Dimitre

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



<Prev in Thread] Current Thread [Next in Thread>