Sorting by item ... of each and item ... of each

[matthias_livecode_150811 at m-r-d.de]

Thanks Phil,

i will try.

> Am 03.09.2023 um 07:22 schrieb Phil Davis via use-livecode <use-livecode at lists.runrev.com>:
> 
> 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_150811 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode