Change Case of String

[RS452]

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

[Luke_C]

@RS452 is there any logic that dictates which words need to be capitalized?

[RS452]

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

[Luke_C]

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! 

[apathetichell]

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