>>>>I want to index on the last three letters of a file name
>>>>and get a list indexed by file extension.
>>>
>>>Firstly, you shuld collect file names/extensions into cursor (using ADIR()). Then you can index your cursor and use it for list.
>>---
>>Hi Ed and thanks...
>>I have a table with files name in it.
>>I want to index on the extensions.
>>I am looking for the index code.. example
>>index on surstr(fieldname,right(filedname,3)) to myindex - or something
>>like that...
>Try :
>index on upper(substr(fieldname,rat(".",filedname)+1))) to myindex
>Beware this one assumes all have extensions.
>Cetin
Oops. Correction :
index on upper(;
iif(occur(".",fieldname),;
substr(trim(fieldname), ;
rat(".",fieldname)+1), ;
""))) to myindex
Cetin