Challenge #182: Word Sleuthing

[JamesMA]

This was a fun challenge. I couldn't get the same record count until I found the trick listed in the hint below:

Spoiler

Use Regex to replace any non-word characters with a '|' or ',' for example. This is necessary as using Text to columns and parsing on \s will not work due to some words not being separated by a space. Using this approach, you ensure each word is split up correctly by a delimeter. 

Spoiler

[meganhan]

My answer, it is the same as solution.

[kmcdaniel]

Very simple, elegant and far better than my solution.  Congrats.

[wcorujo]

First attempt at the Weekly Challenges. Had a lot of fun trying to complete.

[kelly_gilbert]

I wish I could have figured out a way to avoid the second filter using regex, but oh well!

Hints that weren't in the requirements:

Spoiler

1 - "Words" for the purpose of this challenge include any string of alphanumeric characters and underscores
2 - Capitalization is not normalized ("The" and "the" are considered different words)

My workflow (pretty similar to everyone else's):

Spoiler

[Hannah_Lissaman]

My solution 🙂

[Niklas]

Not sure I agree with the parsing approach, but managed to get the matching result 🙂

[jamielaird]

Here's my solution. Similar to others I'm getting higher totals than the posted file.

Spoiler

[nivi_s]

Challenge #182 solved!

Didn't get the same values as the output, but apparently I am not alone in this!

[Sebenius]

A fast one to get back into the habbit.

As for for giving a tip for books to count words in : Project Gutenberg

Spoiler

weekly 182