This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
"The challenge this week is to find the best word (from a provided text file) that can be assembled from 7 provided letters"
I went down a different path than what I have seen posted so far. No macros, finishes in under 2 sec on my laptop, Top 5 for the advanced version verified to @NicoleJohnson's list. I tried verifying to others but had issues downloading or running the workflows. For challenges that don't have answers posted, it would be helpful if others could post screenshots of thier results (like @LordNeilLord did), so we can compare our results without having to download and run everyone's workflows/macros. :>
Congrats to @SeanAdams and others on reaching 75!
Pretty sure @ned has a nicer solution but have a regex based one running in about 7 seconds (with no pre computes) will cope with blanks but not double letters...
Now to cope with repeated letters
@Philip - that solution is beautiful! Much simpler than mine and no pre-computing necessary. And well documented! Nice!
I hadn't considered repeated letters, @jdunkerley79. Had to update to handle them. Thanks for pointing out that need.
I KNEW there was another way to do this. Average of 0.8 seconds for any number of blanks. Now I can sleep again at night!! :)
Ok, this challenge was a quite hard brain game, but I think I got it... I spent 15 minutes trying to figure out what was wrong in my workflow when I finally saw in a regex I forgot to put the + after \d so it was cutting 10 points value into 1, so I was getting wrong results at the end when it was calculating the points for each word.
Anyway, it was a great challenge, I did not think about generating words before with Alteryx, it is not very easy to do but it is possible and to be honest, I thought I would have spent more time on this, but it took me "only" 2 hours.. ahah