Cleaning lists should be autonomous, not monotonous.
This example uses the following transforms to clean and process a list of emails:
–The Dedupe transform removes or combines rows with a duplicate value (i.e. email address).
–The Name Parser transform splits a name field into its constituent parts, i.e. first, middle, last, etc.
–If you want to get fancy, you can use the Find & Replace transform to make sure the email addresses are formatted correctly. In the provided example, we use regular expressions (regex) to make sure the email addresses are correctly formatted and remove ones that aren't.