Change Case of String

Question

Hi All,

I'm looking to change the case of my input to desired output, what is the best suggested route?

Looking for a solution apart from Replace function on the formula tool.

Input - "those who had coins enjoyed the rain. those who had notes were busy looking for shelter."

Output - "Those who had Coins enjoyed the Rain. Those who had Notes were busy looking for Shelter."

apathetichell · Answer

Here's the automated version. Fourth word in both sentence was uppercased along with first and last.

crazy regex.yxmd

Luke_C · Answer

I'm not sure on how it could be done across a set of data then. There are definitely ways to make it work for the one example you provided but I don't think that's what you really would need. There are a lot of smart people here that might have other ideas!

RS452 · Answer

No Logic behind it, I just need to replace the case of few characters within a sentence.