Challenge #433: Ogden’s Basic English – Making Words Count

[Spainey]

Took me a while to find the HTML Rows with the word list in, but once I did it was a simple pattern that allowed me to filter down to all 24 letters (X and Z have no words in Ogden's BASIC English). From there it became a simple parsing exercise.

Spoiler

If I was better at Regex I would have liked to have used that more, but I used Text to Columns to find the unique words and then used a Regex_Replace formula to parse the Word and then found the First Letter in the next cell of the Formula tool. Aggregating helped me get to the correct answer. 

[earth2joy]

Helps to know a bit of HTML for this one.

[nrbarcia_4]

I love having the opportunity to practice RegEx.

Spoiler

[BransonJamesFarley]

Spoiler

 

[SteveY02]

Done. Reference answers G and P have incorrect count data: There are a total of 22 words starting with G, and 59 words starting with P.

[Kilbyflow_Designer]

Done!!!

Spoiler

 

[JBevan89]

Great Challenge

[TH]

This is my take.

Some of it is not as dynamic as I would like. (The sample tools and one of the filters with that does a Regex_match)

I suppose that that is what you get when dealing with real world web scraping.

Also, like others, my answers for 'G' and 'P' are different than the given ones. Looking at the website itself and counting manually I think that my answers are correct.

[JosephSerpis]

Challenege Completed

Spoiler

[Carolyn]

Solved! I had different answers for G & P but when I went to the Wiki page and counted, it matched my solution.

Spoiler

The "little (less, least)" tripped me up for a little bit