Thanks Phil, i will try.
> Am 03.09.2023 um 07:22 schrieb Phil Davis via use-livecode > <[email protected]>: > > 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 [email protected]: >>> >>> 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 >> [email protected] >> 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 > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
