KNOWLEDGE BASE

Convert only the first character of data to uppercase and the second and subsequent character to lowercase in Tableau Desktop


Published: 11 Jan 2023
Last Modified Date: 11 Jan 2023

Question

How to convert only the first character of data to uppercase and the second and subsequent character to lowercase.

User-added image

Environment

  • Tableau Desktop

Answer

The following solution is demonstrated in the attached packaged workbook.

1. Connect to the attached sample data source 'test.xlsx' from Tableau Desktop.
2. Drag Name to Rows.
3. Create a new calculated field with the following definition:
      Name : Name (Converted)
      Calculation : UPPER(LEFT([Name],1)) + LOWER(MID([Name],2))
4. Drag Name (Converted) to Rows next to Name.
User-added image
Did this article resolve the issue?