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

[Reesetrain2]

All,

I found a discrepancy: You get 854 words if you include less, least, more, most. However, when you drop these the count is off just slightly as you get 59 Ps and 22 Gs whereas the solution has 60 Ps and 23 Gs that I verified by copying, pasting, tokenizing and counting....My solution is below.

Spoiler

 

[SaraHamdoun]

Spoiler

 

[Garrett_Stoker]

Spoiler

[Joe-Smith-JLL]

Spoiler

Similar to others, I got a different result for G and P, but match with the main list. 

[AshaDaniels]

Spoiler

 

[Caramel8]

Spoiler

The solution is off by 1 for G and P. 

Spoiler

[pilsworth-bulien-com]

My solution:

Spoiler

[AnaKomissaroff]

Spoiler

My Solution

[Yoshiro_Fujimori]

My solution. (Resubmit as this is not counted. I can use Download Tool at home!)

Spoiler

Workflow

Multi-Row Formula
[Type] = 
IF StartsWith([DownloadData], '<div class="mw-heading mw-heading3">')
THEN "index"
ELSEIF StartsWith([DownloadData], '<p><a href=')
THEN "word"
ELSE Null()
ENDIF

Formula Tool 1
[Index] = REGEX_Replace([DownloadData], ".*>(\u)<.*", "$1")
[RecordID] = [RecordID] + 1

Formula Tool 2
[Count] = REGEX_CountMatches([DownloadData], "</a>")

[RasmusFormo]

Spoiler