Hello,

We use VC to automate file processing. Usually the files come as .psv and we are looking for a way to ensure unique email address. We receive a primary and secondary email address and we want to ensure primary is unique and not duplicated in secondary field. Any ideas for a good way to use VisualCron to accomplish this.

Thanks!

Could you elaborate more what you mean with unique email address and where you want this. Please be as detailed as possible.

---

Yes, I apologize for lack of detail. We currently receive file with primary and secondary email. Primary is for member and secondary is intended for member spouse. We have a problem where our users are populating both primary and secondary with the primary users email address. We need to ensure we do not duplicate addresses and have one unique email address. Not concerned about the secondary email address as long as not duplicate, it can even be blank.
My gut instinct is to use some sort of powershell script to accomplish, but I wanted to check the forum first.

Thanks