Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAA little bit of exploration necessary, but we got there in the end... barring the G&P differences like everyone else.
Here is my solution:
I couldn't get my answer same as the output for G and P, but I think my workflow is correct😁
Thank you, @Tokimatsu, for a great RegEx challenge! I love Regex - well, put it this way, most of the time when it works :)
I followed a similar approach to @TurboToad in solving this challenge - thank you @TurboToad for RegEx Tokenize formula tip!
My "G" and "P" are both off by one, but I think it's formatting in the hyperlink that I ran out of time to diagnose.
(Have I cheated by removing the rows at the top and bottom that aren't part of the word list using a select records tool?)
Always a good time when I get to use the RegEx tool! :) Found a discrepancy in the output with the count from P & G. Each returned one count short from the expected output. Double checked the website and my count is correct, so could be that an edit took place some time in-between.