text sortType

Geoff Canyon gcanyon at gmail.com
Tue May 28 15:32:25 EDT 2013


tested & seems to work:

   sort lines of x numeric by word -1 of item 1 of each
   sort lines of x by word 1 to -2 of item 1 of each



On Tue, May 28, 2013 at 2:26 PM, J. Landman Gay <jacque at hyperactivesw.com>wrote:

> On 5/28/13 2:09 PM, Andrew Kluthe wrote:
>
>> That would handle it for the most part, jaque, but some of the data has
>> multiple words in the first item.
>>
>> Here is a real sample of the most intricate of the data I would be sorting
>> in that first item.
>>
>> MA West Creek 14
>>
>> This would be a string to designate a field code we use. the first two are
>> an abbreviated version of the county the farm is located in, the second is
>> the common name of the farm and the last is a code for the specific chunk
>> of land we are talking about.
>>
>> Sorting by words would work if the second piece of data in that string
>> wasn't multiple words sometimes and I had some way to know how many words
>> were in that item.
>>
>> I am thinking the string is just too variable to sort it down in that way
>> without replacing spaces with another character momentarily.
>>
>
> Maybe:
>
> sort lines of fld 1 numeric by last word of item 1 of each
>
> sort lines of fld 1
>
> --
> Jacqueline Landman Gay         |     jacque at hyperactivesw.com
> HyperActive Software           |     http://www.hyperactivesw.com
>
> ______________________________**_________________
> 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<http://lists.runrev.com/mailman/listinfo/use-livecode>
>



More information about the use-livecode mailing list