A question about Proper() function
Quick issue I'm having with the Proper calculation function. I have a Proper(TextFormatRemove ( Self )) calculation on some fields related to addresses in my database. Works great at preventing lazy data entry. However, there are some issues with using this function. If a sales rep enters a string such that contains text such as "S.E." or "SE" for "Southeast" or "H.Q." or "HQ" for "Headquarters" these sorts of entries will also be have their subsequent letters de-capiltzed (eg. "Hq" or "H.q.")
Is there a way to use a cacluation that will capilizatize words but will not cause de-capitalization on subsequent letters of a word?
We are using Filemaker Pro/Advanced/Server 11.