AnsweredAssumed Answered

All UPPERCASE except the word "and"

Question asked by CRHawk on Jun 20, 2012
Latest reply on Jun 21, 2012 by philmodjunk

Title

All UPPERCASE except the word "and"

Post

I'm trying to create a field calculation that changes all text to uppercase upon entry except the word "AND" or any variation (i.e. "And")

I tried this:

Substitute(Self;[" AND ";" and "] ; [" And ";" and "] ; [" aND ";" and "] ; [" ANd ";" and "] ; [" anD ";" and "] ; [" AnD ";" and "] ; [" aNd ";" and "])

While I'm sure there is a simpler way, the above calculation, at least, worked for the "and" part, I just haven't figured out how to have everything else in uppercase.   If anyone could throw me a bone, I would really appreciate it.

Chad

Outcomes