Weekly Challenge

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

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

Submit Feedback
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.

Challenge #182: Word Sleuthing

Highlighted
8 - Asteroid

Slightly differing results in terms of word count but got there!

Highlighted
8 - Asteroid
Spoiler
sonyakasenkramer_0-1580309863238.png
Highlighted
Alteryx Partner

Fun Challenge!

Spoiler
JustinBabbittEAG_0-1580312816521.png
Highlighted
Alteryx Partner

 

Spoiler
I used the following assumptions to arrive at my answer:
1) All words in lowercase
2) Remove all punctuation
3) Remove all excess whitespace, tabs, new lines, etc.

Capture.PNG

 

 

Highlighted
Alteryx Partner

I was unable to get the exact answer the original poster got, but I believe that's because their solution didn't account for title case vs. lowercase versions of the same word.

 

Spoiler
I appreciated learning how to parse words through this challenge. I originally did it using a text to columns tool because I wasn't aware of the correct syntax to use in a RegEx.
Highlighted
8 - Asteroid

Like many others couldn't get the numbers to match exactly but felt good and confident in what I have.

Highlighted
Alteryx Partner

Regex and counting

Spoiler
dsmdavid_0-1580995253083.png
Highlighted
6 - Meteoroid

Hi,

 

I was debugging my result for the word "The" ,and I found out that i was converting the word to uppercase which was not present in your solution. Due to which your solution counts the word "the" separately for different cases(Upper,Lower and title). Attached is the workflow.

 

Without converting to the same case,

MohithRai_0-1581749667071.png

 

After converting to same case,

The word "THE" will have a count of 79809

 

This was a really awesome exercise and I request you to post many more challenging scenarios like this.

 

Thanks,

Mohith

Highlighted
 
Highlighted
5 - Atom

My answer isn't quite matching up, but here is what I have