I have a data that is being supplied by a third part in all uppercase. I would like convert it to titlecase but I would like the abilty to force certain text strings to be all lowercase and others to be all UPPERCASE.
For example, I would like to end up with:
"Acme Widgets of CA"
"Acme Widgets Of Ca".
This seems like a pretty challenging task. Is there a reasonable way to do this?
Could I do something like this?
Convert these two letter strings that begin with a space to lowercase but do not convert them if they are parts of words such as "attack, issue, office".
Similarly, I need to convert all state abbreviations to uppercase without affecting words that begin with these strings, such as "Cancer, Flowers, Water".