Top 10 Tableau String (Text) Functions in 10-ish Minutes
Mastering Tableau Calculations
Want to take your skills even further? Join us for an 8-hour workshop, Mastering Tableau Calculations on June 21/22! Details on the class and enrollment here: https://www.eventbrite.com/e/masterin...
Video Description
Manipulating text is one of the primary use cases for Tableau calculations. There are all sorts of things you may want to accomplish with string functions.
• Concatenate multiple text values into a single value.
• Grab characters from the beginning, middle or end of a text string.
• Filter on whether certain text criteria are met.
And that’s just the tip of the iceberg! If you want to learn all about Tableau string functions, check out the video below. We cover 10 key functions (LEFT, MID, SPLIT, TRIM, FIND, STARTSWITH, CONTAINS, LEN, REPLACE, STR) and finish with a bonus round and brief discussion surrounding seven extra functions (FINDNTH, ENDSWITH, CHAR, LOWER, UPPER, MIN, MAX, RIGHT).
Want hone your all-around Tableau String/Text functions game? This week’s video is for you!
Want to download the workbook to scope out the calculations? You can access it on Tableau Public here!
https://public.tableau.com/app/profil...
More on Wildcard (text match) filters here:
• Tableau Worksheet Filters Explained
Here are the calculations from the video for each of the 10 functions.
LEFT
[Country Code] | LEFT([Country Code & Name],3)
MID
[Area Code] | MID([Phone Number],2,3)
SPLIT & TRIM
[Military Enlist Category] | TRIM(SPLIT([Military Headcount Status (Military Headcount Status)]," ",1))
FIND
[First Name Length] | FIND([Customer Name]," ")-1
STARTSWITH
[3M Products] | STARTSWITH([Product Name],"3M")
CONTAINS
[Printer / Copier] | CONTAINS([Product Name],"printer") OR CONTAINS([Product Name],"copier")
LEN
[Marriage/Child Status] | TRIM( MID([Military Headcount Status (Military Headcount Status)], LEN([Military Enlist Category]) +1, LEN([Military Headcount Status (Military Headcount Status)])-LEN([Military Enlist Category])-LEN([Gender]) ) )
REPLACE
[Product Name Update] | REPLACE([Product Name],"Eldon","NVent")
STR
[Country Code, Name & Number] | [Country Code & Name] + " (" + STR([Country ID]) + ")"
Chapters:
0:00 LEFT
1:00 MID
2:00 SPLIT & TRIM
4:05 FIND
5:12 STARTSWITH
6:00 CONTAINS
7:25 LEN
11:10 REPLACE
12:07 STR
13:18 Mastering Tableau Calculations
13:50 Bonus (FINDNTH, ENDSWITH, CHAR, LOWER, UPPER, MIN, MAX, RIGHT)