String Calculated Fields
When it comes to string-based logic in Tableau Desktop, users have many options available. If sections of a string need to be parsed out, this can be done positionally. Similarly, string fields can be cleaned positionally or by searching for specific sub-strings. There are a variety of functions available for searching through strings using different methods. The case of lettering can also be modified to uppercase, lowercase, or title case using string functions. For advanced string manipulation, there are also regex functions available.
An example use of string functions in calculated fields that would be useful in the orders data source mentioned in the introduction is the SPLIT
function, which could be used to split customer names in the data source on the space delimiter, resulting in two fields, one for first names and one for last names. There are also string functions that look for specific substrings. For example, CONTAINS
could be used to check...