I believe this works:
on mouseUp
put fld 1 into tList
sort lines of tList by _sortKey(each)
put tList into fld 2
end mouseUp
function _sortKey pLine
set the itemDel to ";"
return item 3 of pLine & ";" & item 2 of pLine
end _sortKey
I realize it isn't as simple as you were looking for, but at least it
avoids doing 2 separate sorts.
Phil Davis
On 9/2/23 6:03 PM, matthias rebbe via use-livecode wrote:
Of course my "not working" sort code look like this
set the itemdelimiter to ";"
sort lines of tList numeric by item 3 of each and item 2 of each.
Am 03.09.2023 um 02:59 schriebmatthias_livecode_150...@m-r-d.de:
Maybe i do not see the forest for the trees....
I have a tab delimited list which i want to sort. I am using this code to sort
it by item 3 and item 2
set the itemdelimiter to tab
sort lines of tList numeric by item 3 of each and item 2 of each.
But that code does not sort as i expected it. Column 2 is not sorted correctly.
The following list is the result.
113254;8420;3016365
113254;8423;3016365
113254;8422;3016365
113254;8420;3016365
113254;8420;3016365
113254;8420;3016365
113254;8421;3016365
203212;8420;3016366
203212;8423;3016366
203212;8422;3016366
203212;8420;3016366
My expectation for example was that for value 3016365 in column 3 the values
in Col 2 would be sorted like this
113254;8423;3016365
113254;8422;3016365
113254;8421;3016365
113254;8420;3016365
113254;8420;3016365
113254;8420;3016365
113254;8420;3016365
Tried also 'by item 2 of each and item 3 of each', but the sort result is
the same?
Am i missing something?
Regards,
Matthias
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
--
Phil Davis
(503) 307-4363
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
