Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #211: Generating Email Addresses

Highlighted
Alteryx
Alteryx

A solution to last week’s challenge can be found hereSource: GIPHYSource: GIPHY

 

This challenge comes to us from @ram_neel - thank you for your contribution!

 

The input file has names of users connected by commas in a single field with random numbers to each name . Some of the names start with a lower case and some have middle name to them. [ names generated using a random name generator website ]

 

Create a set of email IDs (using @testemail.com as the domain) using a combination of first letter of the first name + last name of the user [even if they have a middle name ] and grouped into A-Z categories. Provide a count of the number of emails in each group.

 

Hint - In your output exclude any users without a valid name ( i.e, does not contain a number)

Highlighted
Alteryx Certified Partner

Fun challenge to start the week!

Spoiler
211.PNG

 (edit 4/13 10:31 CDT) video of solution overview:

Spoiler
Highlighted
Alteryx Partner

Fun challenge! Good way to get the gears running on a Monday morning.

 

Spoiler
Like we've seen many, many, many times before, RegEx is king. It's absurd how handy regular expressions are for these types of problems.

Capturev2.PNG

  Check out my solution video here:

Spoiler
Highlighted
Alteryx Partner

Regex is the answer. The question is pretty much irrelevant.

Spoiler
dsmdavid_0-1586788173260.png

 

Highlighted
Alteryx Certified Partner

What is Forrest Gump's email password? 

Spoiler
1forrest1

 

Spoiler
Blake_1-1586788335231.png

 

 

Highlighted
8 - Asteroid
Spoiler
2020-04-13 10_48_51-Greenshot.png
Highlighted
8 - Asteroid

It is very fun It will be more fun if we have more than duplicate mail id.  

Highlighted
Alteryx Certified Partner

My solution

Spoiler
Victor_Mendes_1-1586798724420.png

 

 

 

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
4 tools! 
Capture.PNG

Highlighted
7 - Meteor

EAT

SLEEP

REGEX

REPEAT

Spoiler
MOHAMMEDAFZAL_0-1586800023331.png

Just 5 tools