Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #182: Word Sleuthing

paulburrows
8 - Asteroid

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

sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1580309863238.png
JustinBabbitt
Alteryx
Alteryx

Fun Challenge!

Spoiler
JustinBabbittEAG_0-1580312816521.png
Justin Babbitt
johnemery
11 - Bolide

 

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

 

 

kaianderson
8 - Asteroid

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.
mikeprice17
8 - Asteroid

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

dsmdavid
11 - Bolide

Regex and counting

Spoiler
dsmdavid_0-1580995253083.png
MohithRai
8 - Asteroid

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

Christoph_Pamminger
7 - Meteor
 
naina_e
5 - Atom

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