5 Replies Latest reply on Nov 23, 2011 10:28 AM by philmodjunk

    Using Proper for auto-enter calc, with exceptions?

    DPmax

      Title

      Using Proper for auto-enter calc, with exceptions?

      Post

      I'm working on a field that I would like to use an Auto-Enter calculated value to have all text entered be Proper case.
      Obviously I'd use:
      Proper ( Title )
      Where "Title" is the field I want changed... but here's the catch, I need to allow for things like WWII (world war two) so I don't end up with:
      The Airplanes Of Wwii

      I've looked over a number of posts and all indicate that this really is a tough task, and there was one pointing to this as a solution for names like McDonnell:
      http://www.briandunning.com/cf/837
      Interesting but not hitting what I need.

      What I'm looking for is more of an If or Case function where I could list all the exceptions or changes after the proper function. Even if I had to list all my exceptions I'd be ok with that.

      I know how to do this in text apps like BBEdit using Grep, but not in FileMaker

      Thanks for any assistance.