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.
alteryx Community

# Weekly Challenge

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

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

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

Submit Feedback

## Challenge #267: To Quote The Alphabet

8 - Asteroid

Solution attached

Spoiler
13 - Pulsar

Fun one! 😊

16 - Nebula

My solution.

Good practice.

Spoiler

8 - Asteroid

My solution.

Spoiler
13 - Pulsar

This challenge was fun enough that I decided to try to solve it again another way. I channeled my inner @MarqueeCrew to come up with an all RegEx solution! 😀

Here is my original solution:

Spoiler

RegEx Solution:

Spoiler

RegEx Code

``((?:a+(?(?!b)(*ACCEPT))|b+(?(?!c)(*ACCEPT))|c+(?(?!d)(*ACCEPT))|d+(?(?!e)(*ACCEPT))|e+(?(?!f)(*ACCEPT))|f+(?(?!g)(*ACCEPT))|g+(?(?!h)(*ACCEPT))|h+(?(?!i)(*ACCEPT))|i+(?(?!j)(*ACCEPT))|j+(?(?!k)(*ACCEPT))|k+(?(?!l)(*ACCEPT))|l+(?(?!m)(*ACCEPT))|m+(?(?!n)(*ACCEPT))|n+(?(?!o)(*ACCEPT))|o+(?(?!p)(*ACCEPT))|p+(?(?!q)(*ACCEPT))|q+(?(?!r)(*ACCEPT))|r+(?(?!s)(*ACCEPT))|s+(?(?!t)(*ACCEPT))|t+(?(?!u)(*ACCEPT))|u+(?(?!v)(*ACCEPT))|v+(?(?!w)(*ACCEPT))|w+(?(?!x)(*ACCEPT))|x+(?(?!y)(*ACCEPT))|y+(?(?!z)(*ACCEPT))|z+(?(?!\$)(*ACCEPT)))+)``

Workflow and Output:

Cheers!

Phil

7 - Meteor
Spoiler
12 - Quasar

I feel like I need to spend more time learning the tile tool. I never seem to think of it on a lot of these challenges.

Spoiler

Updated comment: I had no idea about the CharToInt function. Good to know.
Alteryx

My solution:

Spoiler

12 - Quasar

My solution :

Spoiler

17 - Castor

part of the vast conspiracy theory trying to convince everyone to use the substring() function...