Start Free Trial

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

KKSzpakowski
8 - Asteroid

Thank you for the challenge!
I was able to complete it.

Regards
K

CammyPhillips
8 - Asteroid
Spoiler
CammyPhillips_0-1674145639520.png

 

BS_THE_ANALYST
15 - Aurora
15 - Aurora

I like the idea of converting to Titlecase and then performing the counts. The the .. should be grouped if we're counting the instances of the actual words. In English, the/The are the same 😂. I'm not entirely sure I'm going to say 'Hey, by the way, I said hey with a captial H!'

Spoiler
BS_THE_ANALYST_0-1674408392095.png

 

 

All the best,
BS

LinkedIN

Bulien
François_Rs
8 - Asteroid

Franois_Rs_0-1674491795348.png

I didn't manage to find the exact same results

 

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1675177443400.png

 

caltang
17 - Castor
17 - Castor

Can't match exactly, but I managed to do it in a way which is replicable for other Strings:

 

Spoiler
caltang_0-1675583148808.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
gaoa
11 - Bolide
Spoiler
Finally matched solution!
gaoa_0-1675872021552.png

Learned something new about RegEx tool -- splitting entire words to rows.

gaoa_1-1675872744607.png

 

Dani_Lin
8 - Asteroid

solved

longyanChen
8 - Asteroid

hi

Heinrich_Preuß
8 - Asteroid
Spoiler
Heinrich_Preu_0-1676044377114.png

 

The solution has less 'the' because it doesn't include 'The' and 'THE' which I would consider as the same word