Proper Case Broken

Support
1

image

Proper case does not appear to be working.

Desktop Version: 5.4.1.2

2

The function works as expected. From the web help:

Note that words that appear in all uppercase letters retain their case. To convert these strings to proper case, first convert them to lowercase.

3

Thank you, I didn’t realize I have to convert them to lower first. Is there any reason why uppercase retains?

4

Uppercase retains to preserve abbreviations (e.g. NASA) in phrases. The function logic was inherited from .NET, we’ve decided to not change it.

1 Like
5

Hi Dmitry

Using the proper case (field, right mouse, modify, proper case) - create confusion if it is not lower case.

Example: that does not work it Vendor name was upper case
if istext([Vendor name]) then proper([Vendor name]) else [Vendor name]
I know the documentation states it must be lower case.

What is it can be change to automatically have the lower in.
if istext([Vendor name]) then proper(lower([Vendor name])) else [Vendor name]

Just a suggestion..