Tableau Desktop Certified Associate: Exam Guide

Other important string functions

• LEN: This follows the syntax LEN(string). Length is used to find the number of characters in a string. It counts the number of spaces as a character within a string. For example, LEN("Hi There") is 8: 2 for Hi, 1 for space, and 5 for There.
• REPLACE: This follows the syntax REPLACE(string, substring, replacement). REPLACE is used to replace every occurrence of the substring in a string with the replacement, for example, to replace occurrences of special characters such as / or ' in the string, such as Replace([Customer Name],"/","").

Another example would be if someone changed their name. You could replace their name with the new one. Let's replace Aaron Bergman's name with Aaron B. Create a new calculation ...