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

[Craig Newman]

Matthias.

I do not have your original data. But try using “&” instead of “and”.

Craig

> On Sep 5, 2023, at 5:05 PM, Ralph DiMola via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> You can at least detect if the sorting function has failed using a global
> variable.
> 
> global s1
> 
> command test1
>   local t1
> 
>   --put "10,9,8,7,6,5,4,3,2,1" into t1 -- This line will not show an error
>   put "10,9,8,7a,6,5,4,3,2,1" into t1 -- This line will show an error
> 
>   put 0 into s1
>   sort items of t1 numeric by f1(each)
> 
>   if s1 <> the number of items in t1 then answer "Sort Function failed"
>   put t1 & cr & s1
> 
> end test1
> 
> 
> function f1 pEach
>   local tEach
>   put pEach into tEach
>   add 1 to tEach
>   add 1 to s1
>   return tEach
> end f1
> 
> Ralph DiMola
> IT Director
> Evergreen Information Services
> rdimola at evergreeninfo.net
> 
> -----Original Message-----
> From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
> Of matthias rebbe via use-livecode
> Sent: Saturday, September 02, 2023 9:03 PM
> To: How to use LiveCode
> Cc: matthias_livecode_150811 at m-r-d.de
> Subject: Re: Sorting by item ... of each and item ... of each
> 
> 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 schrieb matthias_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
> 
> 
> _______________________________________________
> 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