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.

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

rmassambane
8 - Asteroid

Another one bites the dust!

jamielaird
14 - Magnetar

Here's my solution:

 

Spoiler
jamielaird_1-1624362189787.png
AndrewS
11 - Bolide

#267

Spoiler
267.PNG
mbogusz
9 - Comet
Spoiler
Challenge #267 in the canChallenge #267 in the can
glenperes
8 - Asteroid

Reminds me of Ascii function from my c programming days

Spoiler
Spoiler
267.JPG

RichoBsJ
10 - Fireball

Hi! Here my solution 🙂

dhavaldoshi
8 - Asteroid

How to do it as a Beginner?

I first thought of a transpose of all individual characters and use Multi-Row - So applied the same, check if the current character follows previous one in order, if yes increment the length and then a simple substring

 

Quite proud of my solution! 😄

Spoiler
Solution_267_macro.PNG

 

KaneG
Alteryx
Alteryx

Nice and neat. Use of the tile to get the sequence and CharToInt in order to not need a lookup table

 

Spoiler
KaneG_0-1626245613194.png

 

Elias_Nordlinder
11 - Bolide

Interesting Challenge.
Had to read up on the Multi-Row formula tool a bit more.

 

Spoiler
Elias_Nordlinder_0-1626366831813.png

 

 

ywang7
7 - Meteor
Spoiler
ywang7_0-1626486108784.png