Challenge #358: Goodbye, Michael! (Part 1)

[estherb47]

Different answers than the solution provided. 

Spoiler

Thought through how to do this without summarizing from the summarize tool, and came up with creating unique identifiers for the lines and episodes. Then some fun with the multifield formula tool, and learned that you can pull the field name into the result quite easily!!

[tbennett013]

My solution to Challenge #358

[cameronfraser]

Including numbers in a string snagged me up.

Spoiler

[SandroGerber]

Spoiler

That was a challenging one! Somehow got a slightly different line & word count.

[Leroy]

Thank you for the challenge.

[sgaditya18]

A fun challenge to work on one of my favorite shows! 

[CeliaC_Silje]

Spoiler

The importance of knowing your data through Browse Tool 😏

[RyanG333]

My take on this one

[Ray_Pospisil]

Many people say here that they cannot get the precise result and input data in incorrect.

Currently shared input data in the first post is correct and you can get the precise result.

Fun fact, formula "wordCount" gives different results than parsing with Regex "entire word"

[Mok3bat]

Here's my take.
Thanks a lot.