Thanks Phil, i will try.
> Am 03.09.2023 um 07:22 schrieb Phil Davis via use-livecode > <use-livecode@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_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
