Thanks Panos, you are right. ;) While reading your answer i remembered that i have done this with 2 separate sorts. I really don't know how i thought to use by sortKey1 and sortKey2
But at least the script editor did not return an error. Should not work so late in the night. Matthias > Am 03.09.2023 um 11:26 schrieb panagiotis m via use-livecode > <use-livecode@lists.runrev.com>: > > Hello Matthias, > > I do not think that the syntax "sort <container> by sortKey1 and sortKey2" > is supported > > If you have multiple sortKeys, you have to do multiple sorts, for example, > in your use case, this should work: > > set the itemdel to ";" > sort lines of tList numeric by item 3 of each > sort lines of tList numeric by item 2 of each > > Kind regards, > Panos > -- > > On Sun, 3 Sept 2023 at 08:23, Phil Davis via use-livecode < > use-livecode@lists.runrev.com> wrote: > >> 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 >> > _______________________________________________ > 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 _______________________________________________ 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
