Here's the problem at hand: I have a file with some data like this:
Name;email;zip;status
Joe Doakes;[email protected];07123;A
Nancy Smith;[email protected];98146;I
Armando Gonzales;[email protected];77194;A
I want to semi-anonymize it by changing all the email addresses to end in @example.com
and replacing the ZIP code with a random 5-digit number.