Proper case does not appear to be working.
Desktop Version: 5.4.1.2
Proper case does not appear to be working.
Desktop Version: 5.4.1.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.
Thank you, I didn’t realize I have to convert them to lower first. Is there any reason why uppercase retains?
Uppercase retains to preserve abbreviations (e.g. NASA) in phrases. The function logic was inherited from .NET, we’ve decided to not change it.
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..