From the course: Tableau 10: Mastering Calculations

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Convert and measure strings

Convert and measure strings - Tableau Tutorial

From the course: Tableau 10: Mastering Calculations

Start my 1-month free trial

Convert and measure strings

- [Instructor] Tableau's a terrific numerical visualization tool, but it's also great at handling string data. In this movie I will show you how to convert a number or other value to a string, find the length of a string, and convert a string to upper or lowercase characters. I'll start in Powerpoint, and then move over to Tableau in a moment. The first of the four functions I'll discuss here is STR and that is the string conversion function. You can put anything you want that has an output into the string function, return the value as a string. So it could be a date, a number, true or false, whatever. Next you have LOWER, and LOWER takes a string and changes it to lowercase. So, for example, if you had all capital letters, you could turn them into a lowercase letter string. UPPER does exactly the opposite, it takes a string and changes every character to uppercase if it isn't already, and finally you have L E N, which is short for length. The length function tells you how long a…

Contents