Delete duplicate entries

[MFP]

I have a 1D array of values, some are duplicates, which I need to delete as I only want one copy of each value.

Is there any quick function to do this?

[Tom Haggerty]

Do you want to delete all duplicates or just duplicates that are ajacent to each other?

[Tom Haggerty]

If you just want to delete adjacent duplicates here is a simple solution.

Message Edited by Tom Haggerty on 05-01-2007 07:30 AM

[MFP]

Unfortunately the entries are not nessisary next to each other.

Will your set up still work?

[Tom Haggerty]

No, this is only for adjacent entries, but just a little more work and it will do the rest.  I just didn't know what you needed at the time!

Tom

[Tom Haggerty]

This should work.  Maybe not the best implementation .... but it will work!

Message Edited by Tom Haggerty on 05-01-2007 08:10 AM

[MFP]

Thanks Tom, I'll give it a go!

[sture]

This one also works and is maybe a little bit faster (delet from array is rather slow)..

/Sture

[Ben]

Sture,

If you inititalized an array before the loop, and did a replace array subset inside the loop and after the loop just grab the subset with values....

I believe your code would perform even better.

Ben

[sture]

You mean like the attached picture ? I don't know how to make my pictures visible directly in the message...If I paste a picture inte the message nothing happens, is it a security setting I should change ?

/Sture