>>>>>I want to index on the last three letters of a file name
>>>>>and get a list indexed by file extension.
>>>>
>>>>Assuming that you have filenames loaded into a "files" column of a table:
>>>>
>>>>INDEX ON RIGHT(ALLTRIM(files),3) TO ext_index
>>>---
>>>Hi John and that works - thanks :))
>>
>>Or load foxtools and:
>>
>>INDEX ON JustExt(file) TO ext_index
>
>Technically, that's a lot more accurate than my solution, although it may be slower on large tables. Thanks, George!
I'm not sure it wouldn't be pretty much of a wash. The other solution requires two internal function calls as opposed to one library call. One of the reasons I mentioned it was that "Tahoe" is supposed to include some of the Foxtools functions as part of the language. At least there was some vague reference to it at the last DevCon. This one, and the others dealing with files and drives are, IMHO, the most likely candidates.
George
Ubi caritas et amor, deus ibi est