sorting

Paul Hibbert paulhibbert at mac.com
Sat Aug 9 11:57:34 EDT 2014


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





More information about the use-livecode mailing list