AnsweredAssumed Answered

Using Proper for auto-enter calc, with exceptions?

Question asked by DPmax on Nov 21, 2011
Latest reply on Nov 23, 2011 by philmodjunk


Using Proper for auto-enter calc, with exceptions?


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