sorting - THANK YOU PAUL!!

larry at significantplanet.org larry at significantplanet.org
Sat Aug 9 18:33:40 CEST 2014


Hi Paul,
After trying MANY suggestions and my own trial and ERRORS, you finally 
provided me with a solution that actually works.
I very much appreciate that you actually tested it.
I have the feeling that many times in this list well-meaning people post 
"solutions" that they have not tested and therefore often do not work.
Thanks again,
Larry

----- Original Message ----- 
From: "Paul Hibbert" <paulhibbert at mac.com>
To: "How to use LiveCode" <use-livecode at lists.runrev.com>
Sent: Saturday, August 09, 2014 9:57 AM
Subject: Re: sorting


Larry,

If I understand right, just change the direction of the second sort to put 
the beginners first, this worked for my test:

on mouseUp
   sort lines of fld "sortField" by word 2 of each
   sort lines of fld "sortField" descending by word 1 of each
end mouseUp

Paul

On 2014-08-09, at 4:56 AM, larry at significantplanet.org wrote:

> Hello Alex,
> OK, in my previous email I gave some hypothetical data.
> In my app I actually have a field where the first word is either Advanced 
> or Beginner
> The 2nd word is a number ranging from 2 to 25, showing how many items.
> There are some other words after those, but I'm not concerned about them.
>
> As lines are added to the field, they are in jumbled order.
> What I want is this on the sort: (All the Beginners in numeric order, 
> followed by all the Advanced in numeric order)
> Beginner 1
> Beginner 2
> Beginner 3 (etc.)
> Advanced 1
> Advanced 2
> Advanced 3 (etc.)
>
> Thanks,
> Larry
>
>
> ----- Original Message ----- From: "Alex Tweedly" <alex at tweedly.net>
> To: <use-livecode at lists.runrev.com>
> Sent: Saturday, August 09, 2014 3:51 AM
> Subject: Re: sorting
>
>
> Larry,
> can you be more explicit about how it doesn't work ?
>
> Actually, can you explain better what you want to do ? You said you want
> to sort by the 2nd and then the 3rd word - but gave an example that
> appeared to show sorting by 2nd and 1st - and not even have a 3rd word
> in any line.
>
> So how about a slightly less terse description, and an example showing
> both "before" and "after" and hopefully we can get you to where you want
> ....
>
> -- Alex.
>
>
> On 09/08/2014 09:14, larry at significantplanet.org wrote:
>> Sorry, that doesn't work
>>
>> ----- Original Message ----- From: "Björnke von Gierke" <bvg at mac.com>
>> To: "How to use LiveCode" <use-livecode at lists.runrev.com>
>> Sent: Saturday, August 09, 2014 12:58 AM
>> Subject: Re: sorting
>>
>>
>>> sort theList by word 2 of each
>>> sort theList by word 1 of each
>>>
>>> sort order is retained in-between commands, that's why it works.
>>>
>>> On 09 Aug 2014, at 08:24, larry at significantplanet.org wrote:
>>>
>>>> I have a field I want to sort.
>>>> Each line has 4 words.
>>>> I want to sort by the first word (ascending) and then do a 2nd sort by 
>>>> the 3rd word without changing the order of the first word.
>>>>
>>>> Example:
>>>>
>>>> apple  box
>>>> apple  pie
>>>> apple  zoo
>>>> baby  blue
>>>> baby  rattle
>>>> baby  zoo
>>>> etc.
>>>>
>>>> TIA
>>>> Larry
>>>> _______________________________________________
>>>> 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
>>
>>
>> _______________________________________________
>> 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
>
> _______________________________________________
> 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 




More information about the use-livecode mailing list