What is a String in Tableau?

In Tableau, a string is simply a sequence of characters, also known as text data. It’s the data type used for everything from customer names and product categories to addresses and ID numbers. This article will show you exactly what strings are, why they are essential for your dashboards, and how to use powerful string functions to clean, transform, and analyze your text data.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly is a String in Tableau?

Think of strings as the primary way you provide context in your data. While numbers (integers, decimals) are what you typically measure, strings are what you use to label, categorize, and describe those measurements. If sales revenue is the "what," then the product name, region, and customer segment - all strings - are the "who," "where," and "why."

Tableau is smart enough to recognize text-based fields upon import and automatically assign them the String data type. You can easily spot a string field in your Data pane by the small “Abc” icon next to its name.

Here are some common examples of data that should be classified as strings:

• Names: ‘Jane Doe,’ ‘Acme Corporation’
• Categories: ‘Office Supplies,’ ‘Technology,’ ‘Furniture’
• Geographic Data: ‘New York City,’ ‘California,’ ‘United Kingdom’
• Qualitative Feedback: ‘The product was excellent,’ ‘Shipping was delayed’
• Unique Identifiers: ‘ORD-2023-10543,’ ‘SKU-TEC-10023’

You might notice that some identifiers, like ZIP codes or order IDs, contain numbers but are best treated as strings. Why? Because you typically wouldn't perform mathematical calculations on them. For instance, finding the average ZIP code doesn't provide a useful insight. Treating them as strings ensures they are used as distinct labels or categories instead of numerical values.

Why Strings are the Foundation of Your Visualizations

Strings are almost always used as Dimensions in Tableau. Dimensions are fields that you use to segment your data. When you drag a string field onto the Columns or Rows shelf, Tableau creates headers and slices your view into separate panes for each unique string value. This ability to categorize data is fundamental to visual analytics.

At their core, strings serve a few critical functions in any dashboard:

• Categorizing Data: Strings let you break down your measures. A bar chart showing total sales is useful, but a bar chart showing sales by Region (a string) immediately tells you where your best-performing areas are.
• Creating Labels: Strings act as the labels for your data points. Adding a Product Name string to your visualization allows viewers to see exactly which product is driving the most revenue.
• Providing Detail: You can add string fields to the Tooltip mark to offer more descriptive information when a user hovers over a data point. This is perfect for showing product descriptions, customer comments, or location addresses without cluttering your main view.
• Building Hierarchies: You can create powerful drill-down hierarchies with multiple string fields. For example, a user could start by viewing sales by Category, then click to expand it to Sub-Category, and finally down to the individual Product Name.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Work with Strings in Tableau: Common Functions and Techniques

Real-world data is rarely perfect. It often arrives with inconsistencies, extra spaces, or fields that need to be combined or separated. Tableau provides a powerful set of built-in functions that allow you to manipulate your string data directly within a calculated field, saving you from having to clean the data in a separate tool.

Changing a Data Type to a String

Sometimes, Tableau might misinterpret a field. A field containing years like 2022, 2023, and 2024 might be imported as a number. If you want to use it as a categorical label rather than a continuous numerical value, you should convert it to a string.

You can do this easily in the Data pane by clicking the data type icon (# for number, calendar for date, etc.) next to the field and selecting "String."

You can also do this in a calculated field using the STR() function. This creates a new version of the field while preserving the original.

STR([Year])

Splitting Strings for More Granular Analysis

A very common task is breaking apart a single-string field into multiple fields. Imagine your data contains a Full Name field like "Alex Garcia," but you want separate columns for First Name and Last Name. Tableau's Split functionality makes this easy.

Automatic Split

For simple splits, you can choose an automatic split. Tableau will examine the string values, identify a common delimiter (like a space, comma, or hyphen), and separate the field for you.

1. In the Data pane, right-click on the string field you want to split.
2. Navigate to Transform > Split.
3. Tableau will create new fields for each part of the original string. For "Alex Garcia," it would create "Full Name - Split 1" (Alex) and "Full Name - Split 2" (Garcia).

Custom Split

If Tableau can’t automatically detect the delimiter or if you need more control, a custom split is the answer. For example, if you have a Product ID like "FUR-CHR-10023-A", you could use a custom split to separate the category, sub-category, and numerical ID.

1. Right-click the string field in the Data pane.
2. Navigate to Transform > Custom Split....
3. In the dialog box, enter the delimiter (e.g., "-").
4. Choose to split off the "First," "Last," or "All" occurrences and specify the number of new columns to create.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Combining Strings with Concatenation

The opposite of splitting is combining, or concatenating. You can merge multiple string fields into a single field using the + operator in a calculated field. For example, to create a Full Address field from separate City, State, and Postal Code fields, you can use a formula like this:

[City] + ", " + [State] + " " + STR([Postal Code])

This formula combines the city, adds a comma and a space, adds the state, adds another space, and finally appends the postal code. Note we used the STR() function to convert Postal Code from a number to a string first, ensuring the concatenation works correctly.

Cleaning and Standardizing Text Data

Messy text is a data analyst's worst nightmare. Inconsistent capitalization ("USA," "usa," "Usa") or unwanted whitespace can cause Tableau to treat identical values as distinct categories. String functions are your first line of defense.

LOWER() and UPPER()

These functions convert a string to all lowercase or all uppercase, respectively. This is the simplest way to fix capitalization issues.

Example: To standardize a country field, create a calculated field named Country (Standardized):

UPPER([Country])

Now, every country value will be in uppercase, allowing Tableau to correctly group them.

TRIM(), LTRIM(), and RTRIM()

Whitespace is an invisible issue. A string like " California " with leading and trailing spaces will be treated differently from "California". The TRIM() function removes spaces from both the beginning and end of a string. LTRIM() removes only leading spaces, and RTRIM() removes only trailing spaces.

Example:

TRIM([State])

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Finding and Extracting Information Within Your Strings

Sometimes you don't need to split a whole string, but just extract a piece of it or check if it contains specific text.

CONTAINS()

This function checks if a string contains a specific substring and returns a Boolean result (True or False). It’s incredibly useful for creating flags or filters.

Example: Suppose you want to identify all "organic" products based on their descriptions. You could create a calculated field named Is Organic?:

CONTAINS([Product Description], "organic")

You can then drag this new field to the Filters shelf and select "True" to see only organic products.

LEFT(), RIGHT(), and MID()

These functions let you extract a specific number of characters from the beginning, end, or middle of a string.

• LEFT(string, number): Returns the first X characters from the string.
• RIGHT(string, number): Returns the last X characters from the string.
• MID(string, start, [length]): Returns characters from the middle of the string, starting at a specific position.

Example: From an Order ID like "US-2023-12345," you can extract parts:

• Country Code: LEFT([Order ID], 2) returns "US"
• Year: MID([Order ID], 4, 4) returns "2023"

Tips for a Smoother Workflow with Strings

• Perform Cleaning Early: Correcting messy string data should be one of the first steps you take. Standardize casing and trim whitespace to ensure accurate grouping and analysis from the start.
• Use Groups for Quick Fixes: If you only have a few inconsistencies (e.g., 'NY' and 'New York'), you can right-click the field and select "Create > Group" to manually combine them without writing a formula.
• Check Data Types on Import: Always take a quick look at your Data pane after connecting to a new source. Make sure IDs and codes that should be strings were not incorrectly imported as numbers.

Final Thoughts

Strings are much more than just text - they are the dimensional framework that gives meaning and context to your visualizations in Tableau. By learning to split, combine, clean, and extract information from your string fields, you unlock a deeper ability to prepare your data and uncover the narratives hidden within it.

While mastering Tableau's functions is a powerful skill, we know building detailed reports still involves hours of manual setup, from connecting sources to wrangling data and configuring charts. We built Graphed because we believe getting to the insight should be much faster. You can connect all your marketing and sales data, then simply ask questions in plain English - like "Show me a bar chart of sales by product category for last quarter" - and watch a real-time dashboard appear in seconds, without any manual cleaning or chart building.