Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #458: Masking Alternating Characters

martinson
11 - Bolide

Great Challenge

Cheers,
martinson

LinkedIN

Bulien
fmilliren
8 - Asteroid

My solution matches the format of the instructions but record #2 in the Output provided within the start file doesn't line up with the instructions as the second character of the first word is hashed not the first character, nor does the space get skipped in the count as it does in the instructions where the first character of each word gets hashed regardless of placement in the full string. I feel like there has to be a more efficient way to use RegEx to get the hashing to work without the extra steps; I just don't know what it is.

Still a fun challenge to work on. 

Spoiler
Challenge458_solution_image.png

Edited to remove duplicate spoiler tag.

rmassambane
11 - Bolide

458

RebekaMazuchova
8 - Asteroid

:)

jrlindem
11 - Bolide

Good use for the Multi-Row Formula tool!

 

Spoiler
jrlindem_0-1755111674881.png

 

Maerushee
5 - Atom

Solution

JBevan89
8 - Asteroid
Spoiler
JB_C458.png

 Great Challenge

surimil
6 - Meteoroid

surimil_0-1759087741788.png