Challenge #174: Appyhay Ondaymay!

[JamesCharnley]

Spoiler

One of those where I just kept having to add more tools to account for more cases of punctuation and capitals but got the full solution in the end.

[ahsanaali]

Spoiler

[Thomas_Wells_2dot0]

Olutionsay ttachedayay. Okyay isthay asway ayay otlay arderhay anthay expectedyay.  Iyay usedyay ayway ootay anymay ormulafay unctionsfay utbay I'myay appy with the solutionhay.

Spoiler

 

[tammybrown_tds]

I couldn't figure out how to get the "quote" in front of the word "On'tday" in Sentence 10.  I'd already spent wayyyyyy too much time on the challenge, so it is what it is.

Not my favorite challenge...too much manual coding.

[FinnCharlton]

Spoiler

[StanleyKinnok_Chan]

here is my solution

[kristiadiuisan]

Spoiler

[AndrewHoData]

Learnt lots from this challenge. Very fun and challenging!

The workflow looks deceptively simple.

Spoiler

And for my future forgetful self, the formulas used...

Spoiler

 

Regex_match( Titlecase( [Field] ), [Field], 0 ) is particularly useful for finding out if a field has an uppercase or not

And the summarize options to use

Spoiler

[leonhekkert]

Very nice challenge. :)

Spoiler

[alacoume]

My solution: