Exciting news for Tableau users! With version 2022.4, Tableau has introduced the highly anticipated PROPER() function. This function makes it easy to transform string data into title case format, where the first letter of each word is capitalized, and all other letters are in lowercase.
It offers a quick solution for formatting names and proper nouns that are either lowercase, uppercase or inconsistent case. By using this function, you can format your text in a visually appealing way with minimal effort.
Here’s is how it works:
Why is this significant for Tableau users? Achieving title case in Tableau previously involved using a combination of functions, such as LEFT(), RIGHT(), UPPER(), LOWER() and regex. However, for strings with multiple words, this could quickly become complex. As an illustration, consider the following workaround calculation, which accounts for up to four words in a string:
(This older blog describes it in more detail)
With the old workaround, more words also mean longer calculation code. In contrast, the PROPER() function is more robust and much easier to use, since you need only one short line of code independent of how long your text is.
We hope you found this article helpful. For more information on the latest Tableau features, be sure to check out our other blog posts below, and reach out if you’d like to work with us.