Challenge #56: Parsing and Counting Hashtags

[mceleavey]

Good call.

Seconded.

[JoeM]

The solution for Challenge #56 is now posted! It's great to see the many way this was solved!

[SeanAdams]

kinda a mix between a few of the solutions posted above.

Spoiler

I used the text-to-column to split at the hash mark into rows, so that it can work over any number of hashtags in the text (probably a smarter way to do this using a tokenize in RegEx, but this was dead quick
Then regexed out the hashtag
then summarized it all up using a crosstab and a dynamic rename with formula

[NicoleJohnson]

My solution! :) [Edited to actually include the solution now... oops.]

Spoiler

[estherb47]

another fun one! 

Spoiler

Spoiler

[Natasha]

I don't use regex a lot, so got stuck for quite some time on rows with several hashtags.

Spoiler

[LordNeilLord]

I spent ages trying to get the RegEx right but once I had conquered that the rest was plain sailing:

Spoiler

[nick_ceneviva]

Solution Attached

[jamielaird]

Here's my solution.

Spoiler

[patrick_digan]

Spoiler