Issue with System.Collections.ArrayList.Contains function

Hi

I am writing a script that takes data from a source and puts it into a destination data table.

The script should check if the record already exists in the destination table by checking the ID.

I have used the ArrayList.Contain functionality to do this in the past with good success. I am running into a bug where the source data seems to always be added. When I check the data I see I have duplicate records. I thought my script was not allowing for that? I can't quite see what the issue is as I used very similar code previously and it worked fine.

Here is some code. I can provide a sample file if that is helpful.

Any thoughts would be appreciated.

Please Login or Register  to view this content.

Hi,

Thanks for your reply and interest in helping me solve this issue.

• I am not too sure about the trailing spaces suggestion, but when I do an EXACT() comparison of the two ID ranges it does return as TRUE...
  
• I attached a sample sheet with 20 rows of dummy data. The dummy data is both in the source and the destination sheets, so I would expect that the script does not create any more rows in the destination table..
  
• Note that I have also enabled conditional formatting of duplicates in the destination range in order to highlight where duplicates exist.

Any and all help would be appreciated, as I will be managing a huge volume of this data in the next few months.

Thank you!

You should add the value to the ArrayList not the range.
Change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Thank you!

That was indeed the issue. I will mark the thread as solved!

You're welcome, glad to help & thanks for the feedback.