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.