Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

Hannah_Lissaman
11 - Bolide

My solution 🙂

Reesetrain2
9 - Comet

All,

 

My submission is below

Spoiler
Capture.PNG
NicoleJohnson
ACE Emeritus
ACE Emeritus

My solution!

 

Spoiler
For anyone tripped up by the particulars, here are a few helpful hints: 
1. User Uppercase() to standardize the first letter of the email address
2. RegEx is your friend (per the usual, in my opinion... #RegExForTheWin)
3. Never a bad time to plug the CReW macros & the "Expect Equal" tool for the quickest way to make sure you got your answer right!

WeeklyChallenge211.JPG

Cheers!

NJ

hanykowska
11 - Bolide

had to do a retake a few times, but that's what you get for not reading the instructions properly!

 

Spoiler
image.png
tavakian
7 - Meteor

 

Spoiler
Spoilertavakian_1-1588378279987.png

 

 

 

thenumberstim
7 - Meteor
Spoiler
thenumberstim_0-1588445146921.png

 

Solved

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached

 

Spoiler
WorkflowWorkflow
jiteshthegenius
7 - Meteor

Spoiler

joshuaburkhow
ACE Emeritus
ACE Emeritus

Good one to hone a couple uncommon formula functions

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
zajaccount
9 - Comet

My solution attached.