Challenge #211: Generating Email Addresses

[SylwiaDragon]

Done

[RobbieA]

Solution for 211!

Spoiler

[BSilverblatt]

Thanks for the challenge! Here's my solution:

[SPetrie]

Fun challenge

Spoiler

[MCooper]

Spoiler

[DanielvanLeuzen]

my solution

[okimoto001]

done

[TonyAndriani]

Reposting under my new user ID.

[mpennington]

Nice exercise, but doing this in real life there would be the challenge of dealing with individuals with the same first initial and last name. I tested for it, but it didn't exist in this dataset.  

Spoiler

Formula I used to create the emails once I tokenized the users. 

Uppercase(REGEX_Replace([Users], '(\w)(\w+)\s*(\w*)\s([A-z]*)(\d+)', '$1'))
+REGEX_Replace([Users], '(\w)(\w+)\s*(\w*)\s([A-z]*)(\d+)', '$4@testemail.com')​

[FrederikE]

Spoiler