sorting

larry at significantplanet.org larry at significantplanet.org
Sat Aug 9 07:56:00 EDT 2014


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 





More information about the use-livecode mailing list