8 Replies Latest reply on Jun 21, 2012 6:41 AM by philmodjunk

    All UPPERCASE except the word "and"

    CRHawk

      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