I don't really know if this is a scritp matter or a calculation one.

I have a table with many customers' emails.

I use a script that picks them up from every record and place them into a field but sometimes two customers have the same email.

How could I "clean" those duplicates?

Thank you.

What i would do is create another TO of the customers table where emails are @

Create a multi-predicate join using

CUSTOMER_ID = CUSTOMER_ID

&

Customer_email = Customer_email

the new TO ( table occurrence can be placed on a new layout and you can compare the 2 portals to see the dups.

hope that helps.

-i

Thank you for your answer imoree but is not exactly what I'm looking for.

I have done this script to pick all customers' emails and send an email to all of them at once (in gmail format ", ").

I don't need to compare them, and there's no problem if a few customers share the same email on the DB.

What I try to avoid is not to send the same email a few times to the same email account.

Through my scritp I populate a field with all the email accounts found in my customers table, all separated by comma and a space.

The question is: is there a way to filter the duplicates, or while my variable is picking them up, not to pick a duplicate?

Thanks to all.

You could make a value list of the email field, and then use Substitute(ValueListItems(Get(FileName);"emailVL");"¶"; ", ") .

You can use the last advice or use a Unique custom function. EASY

Thanks to all for your replies.

Doughemi, your advice works just fine. Thank you.