Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sorting 2 variables: one ascending, one descending
#22
Quote:I suppose if the sorting column were alphanumeric, you would be better off "subtracting" it from a string of CHR$(255)'s. For each character "x" in the string, replace it with CHR$(255-ASC("x")) in the sortkey.
*peace*
Meg.
MEG: Forgive me. In my last post I was so excited with the fact the Neo came up with the XOR solution, that I neglected to acknowledge your equally elegant solution with has exactly the same effect using arithmetic instead of the XOR bit-wise logic.

I consider that both you and Neo are the co-winners of the challenge by demonstrating that manipulation of the sort key can solve an otherwise sticky sorting problem. Hurrah to you both. Big Grin
Reply


Messages In This Thread
My Submission - by Meg - 11-08-2004, 10:26 PM
Hey!.. - by ToohTooh - 11-08-2004, 11:16 PM
Now this is serious. - by ToohTooh - 11-10-2004, 07:13 PM
Sorting 2 variables: one ascending, one descending - by Moneo - 11-14-2004, 05:20 AM

Forum Jump:


Users browsing this thread: 2 Guest(s)