Title Case Formatting in Tableau with the PROPER() Function

Data

Title Case Formatting in Tableau with the PROPER() Function

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: 

Strings of code in Tableau showing a workaround for all capitalization statuses

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

More About the Author

Gheorghe Ghidiu

Analytics Architect
How To Use Tableau Repository to Monitor Your Tableau Server Looking to optimize your Tableau Server? If you are reading this, you are most probably on the right path. But how do you know where to ...
Title Case Formatting in Tableau with the PROPER() Function Exciting news for Tableau users! With version 2022.4, Tableau has introduced the highly anticipated PROPER() function. This function ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!