community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #174: Appyhay Ondaymay!

Asteroid

m sure this is correct, but the expected translates you to youyay (as if it begins with a vowel). But heres my go, it deals with the punctuation, casing and spaces (so many trailing spaces ) would like to come back to this and make it more reasuable.

Spoiler
 

 

 

 

 

Alteryx Certified Partner

Quite a bit of tweaking involved in this problem!

 

Spoiler
challenge_174.PNG

 

Meteor
Spoiler
clipboard_image_0.png
Close enough. Spent enough time on this. Didn't capitalize sentences and I have some incorrect quotes. Learned about the ::punct:: regex though.
Alteryx
Alteryx

There has to be a cleaner solution than this. But I did want to make sure that any group of consonants however long, would be properly translated (thinking of words like "chrysalis").

Meteoroid

Had to do it two times because I didn't like how I did it the first time.

Spoiler
clipboard_image_0.png
Alteryx Partner

Surprisingly complicated with all the different possibilities....

Nebula
Nebula

This is a great example of

a) a challenge that is directly tied to some of the interactive training that's available  https://community.alteryx.com/t5/Interactive-Lessons/Using-RegEx-in-Expressions/ta-p/424427

b) a workflow that is different during development than the final product

 

Good fun - thank you!

 

Spoiler

Build this using a flow that broke this into one word at a time to make it easier to debug:
Trick is to use Regex that uses named elements ($1) to do this fairly simply

Split Flow by Word.pngTestingInProgress.png


The final flow then removes the TextToColumns tools to keep the sentances whole.

FinalFlow.png

Highlighted
Meteor

There are a number of different solutions here, I have used regex in mine, but I'm not sure how well it would work if there were numbers as well as letters.

 

Spoiler
Capture.PNG
Alteryx Partner

Challenge 174 completed in just 6 tools! Got to love RegEx!

 

Spoiler
challenge 174 JMS solution.PNG