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 <jac...@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 | jac...@hyperactivesw.com > HyperActive Software | http://www.hyperactivesw.com > > ______________________________**_________________ > use-livecode mailing list > use-livecode@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> > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
