J. Landman Gay
jacque at hyperactivesw.com
Tue May 28 15:26:31 EDT 2013
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.
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
More information about the Use-livecode