Weekly Challenge

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

AYXAcademy
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)

Aaron_Harter
11 - Bolide

Fun challenge to start the week!

Spoiler
211.PNG

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

Spoiler
johnemery
10 - Fireball

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
dsmdavid
11 - Bolide

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

Spoiler
dsmdavid_0-1586788173260.png

 

Blake
12 - Quasar

What is Forrest Gump's email password? 

Spoiler
1forrest1

 

Spoiler
Blake_1-1586788335231.png

 

 

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

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

Victor_Mendes
7 - Meteor

My solution

Spoiler
Victor_Mendes_1-1586798724420.png

 

 

 

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

MOHAMMEDAFZAL
7 - Meteor

EAT

SLEEP

REGEX

REPEAT

Spoiler
MOHAMMEDAFZAL_0-1586800023331.png

Just 5 tools 🙂