Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #211: Generating Email Addresses

balajilolla
8 - Asteroid

Enjoyed solving this challenge!

 

Spoiler
Solution Attached
ramesh_neel
11 - Bolide
11 - Bolide

@kelly_gilbert  - Thanks for solving this and I am so glad you liked it! Cheers

Alteryx ACE | Sydney Alteryx User Group Lead | SparkED Contributor and Mentor
AbhilashR
15 - Aurora
15 - Aurora

Solution attached

randreag
11 - Bolide

Here is my solution

Kennybarker29
5 - Atom

Evening,

 

This is my second Weekly Challenge - had a go after scoring 79.9% on the Core Certification which i'm devastated about. Definitely not the most elegant solution after looking at some others here - and i had a bit of a nightmare with the RegEx, but it definitely works!

goyalrav
5 - Atom
Spoiler
Capture.PNG

My First Workflow!!

 

Steph_Maddrell
8 - Asteroid

My solution attached and screenshot below

 

Spoiler
stephM_0-1588004870394.png

 

Kale_Malcom
8 - Asteroid
Spoiler
Kale_Malcom_0-1588027145061.png

 

first time I've used the OR | in regex...

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 211 is done...Regex to the rescue! (formulas can be seen in the spoiler below)

 

Spoiler
image.png

Filter formula: REGEX_Match([Users], '.*\d+$')

Formula (Email_Group): Uppercase(REGEX_Replace([Users], '^([A-Z]).*', '$1'))

Formula (Users): REGEX_Replace([Users], '^([A-Z]).*\s(.*?)\s?\d+$', '$1$2') + '@testemail.com'

duartepimentel
8 - Asteroid

Fun challenge!

 

Solution attached