text sortType

[J. Landman Gay]

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