Challenge #174: Appyhay Ondaymay!

[JamesCharnley]

スポイラ

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]

スポイラ

[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.

スポイラ

 

[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]

スポイラ

[StanleyKinnok_Chan]

here is my solution

[kristiadiuisan]

スポイラ

[AndrewHoData]

Learnt lots from this challenge. Very fun and challenging!

The workflow looks deceptively simple.

スポイラ

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

スポイラ

 

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

スポイラ

[leonhekkert]

Very nice challenge. :)

スポイラ

[alacoume]

My solution: