>>Any simple way to remove duplicates in a one dimensional array? No specific order to the rows and the elements are text. I'm thinking of looping through, and comparing elements, but the no-order thing has got me paused... Thanks!
>>
>>Regards, Renoir
>
>Renoir,
>
>I don't know how many items you have in the array, but my first thought is this:
>
>create table temp (cElement c(20))
>iterate through the elements and append to table
>select * from temp ;
> order by cElement ;
> group by cElement into cursor tempCursor
>create a newArray (or redimension old one, and reuse it)
>scan/endscan through tempCursor and put into new array
>
>Should work pretty quickly...
Steve,
Honestly cursor way being the first thought for me too I wanted to make a note here. After creating the cursor you don't need to iterate through elements to append, append from array or insert into myCursor from array myArray works (provided that first you make it 2 dimensional with one column first) :
dimension myArray[alen(myArray,1),1]
create cursor temp (cElement c(20))
append from myArray
insert into temp from array myArray
Cetin