>I have a file that has several duplicate name in the file. I remembered you could index the file with a command like INDEX on Contact_name to t Unique.Which would index all records on the field Contact_name. But how do I extract/copy the unique records out of the file?
Unique 'records' could be 'select distinct *...'
Unique contact names 'select distinct contact_name...'
Indexing with unique only gets first occurence of its index expression.
*Index on Contact_name tag U_Contact unique
set order to tag U_Contact
copy to SomeWhere
Note that this is different from SQL distinct.
Cetin