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
