{"id":10226,"date":"2018-03-08T08:30:11","date_gmt":"2018-03-08T08:30:11","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=10226"},"modified":"2025-03-01T15:27:37","modified_gmt":"2025-03-01T09:57:37","slug":"string-functions-in-tableau","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/","title":{"rendered":"String Functions in Tableau"},"content":{"rendered":"

In this Tableau tutorial<\/strong><\/a>, we are going out to learn about string functions in tableau. We will discuss all twenty Tableau String Functions including ASCII, CHAR, CONTAINS and many other String functions with examples. So let\u2019s begin with String Functions in Tableau.<\/p>\n

String Function in Tableau<\/h3>\n

An assortment of inbuilt string capacities are given by Tableau which empower string controls like looking at, connecting, supplanting characters from string, and so forth.<\/p>\n

Functions in Tableau String Functions<\/h3>\n

i. ASCII Function<\/h4>\n

ASCII(string)<\/p>\n

The ASCII String functions returns the ASCII code for the first character in the string.<\/p>\n

Example:<\/strong>
\nASCII(\u201cAlabama\u201d) = 65
\nRead about Tableau Navigation in detail<\/strong><\/a><\/p>\n

ii. CHAR Function<\/h4>\n

CHAR(integer)<\/p>\n

This String functions works in the reverse of the ASCII function. It converts an integer ASCII code into a character.<\/p>\n

Example:<\/strong>
\nCHAR(65) = \u2018A\u2019<\/p>\n

iii. CONTAINS Function<\/h4>\n

CONTAINS(string, substring)<\/p>\n

The CONTAINS String functions will return a TRUE value if the string contains the substring and a FALSE if it does not.<\/p>\n

Example:<\/strong>
\nCONTAINS(\u201cInterWorks\u201d, \u201cWorks\u201d) = TRUE<\/p>\n

iv.\u00a0ENDSWITH Function<\/h4>\n

ENDSWITH(string, substring)<\/p>\n

A similar function to the one above, the ENDSWITH string functions tests if the string ends with the selected substring, returning either TRUE or FALSE.<\/p>\n

Example:<\/strong>
\nENDSWITH(\u201csoftware\u201d, \u201cware\u201d) = TRUE<\/p>\n

v.\u00a0FIND Function<\/h4>\n

FIND(string, substring, [start])<\/p>\n

The FIND string functions returns the start of the substring within the string. The first character in the string is position 1. If the substring is not found, it will return a value of 0.
\nFIND(\u201cOklahoma\u201d, \u201cla\u201d) = 3
\nIf the start argument is also defined, any instance of the substring that appears before the start will be ignored.<\/p>\n

Example:<\/strong>
\nFIND(\u201cMississippi\u201d, \u201ciss\u201d, 4) = 5
\nRead about How to install\u00a0Tableau in detail<\/strong><\/a><\/p>\n

vi. ISDATE Function<\/h4>\n

ISDATE(string)<\/p>\n

This is a logical test that is also included in the list of logical functions. It tests a string to determine if it is a valid date (true\/false). This String functions is also included in the Date Functions.<\/p>\n

Example:<\/strong>
\nISDATE(\u201cSeptember 29, 2014\u201d) = true<\/p>\n

vii. LEFT Function<\/h4>\n

LEFT(string, num_chars)<\/p>\n

This String functions returns the characters of the string using the specified number as the amount.<\/p>\n

Example:<\/strong>
\nLEFT(\u201ccheetah\u201d, 4) = \u2018chee\u2019
\nIf the start_of_week is omitted, then it is determined by the data source<\/strong><\/a>.<\/p>\n

viii. LEN Function<\/h4>\n

LEN(string)<\/p>\n

The LEN String functions (or length function) returns the character count of the given string field.<\/p>\n

Example:<\/strong>
\nLEN(\u201cMissouri\u201d) = 8<\/p>\n

ix. LOWER Function<\/h4>\n

LOWER(string)<\/p>\n

This String functions converts all characters in the given string into lower case letters.<\/p>\n

Example:<\/strong>
\nLOWER(\u201cTableau\u201d) = \u201ctableau\u201d
\nRead about Tableau Data Extract \u2013 How to do Data Extraction in Tableau in detail<\/strong><\/a><\/p>\n

x. LTRIM Function<\/h4>\n

LTRIM(string)<\/p>\n

It removes any spaces starting the string.<\/p>\n

Example:<\/strong>
\nLTRIM(\u201c Harry\u201d) = \u201cHarry\u201d<\/p>\n

xi. MAX Function<\/h4>\n

MAX(a, b)<\/p>\n

The MAX function exists in several categories of functions, including String Functions. When used for strings, the MAX function returns the value that is highest in the sort sequence defined by the database for that field\u2019s column. If either field is NULL, then the function will return NULL.<\/p>\n

Example:<\/strong>
\nMAX(\u201cApple\u201d, \u201dBanana\u201d) = \u201cBanana\u201d<\/p>\n

xii. MID Function<\/h4>\n

MID(string, start, [length])<\/p>\n

The MID String functions returns the characters from the middle of a text string. The start argument is where the returned value will begin and the length argument is how many characters will be returned. If the length is not included, then all remaining characters after the start position will be included. The first character in the string is position 1.<\/p>\n

Example:<\/strong>
\nMID(\u201cStillwater\u201d, 3, 2) = \u201cil\u201d<\/p>\n

xiii. MIN Function<\/h4>\n

MIN(a, b)<\/p>\n

Similar to the MAX function, the MIN function returns the minimum between a and b, which must be of the same data type (i.e. string). With strings, the MIN function will return the lower value based on the sort sequence as defined in the database. If either argument is NULL, then this String functions will return NULL.<\/p>\n

Example:<\/strong>
\nMIN(\u201cApple\u201d, \u201cBanana\u201d) = \u201cApple\u201d
\nRead about Tableau Field Operations in detail<\/a><\/strong><\/p>\n

xiv. REPLACE Function<\/h4>\n

REPLACE(string, substring, replacement)<\/p>\n

This String functions will replace find any occurrence of the substring in the string and replace those characters with the replacement string. If the substring is not found in the string, then there is no change.<\/p>\n

Example:<\/strong>
\nREPLACE(\u201ccalculation\u201d, \u201cion\u201d, \u201ced\u201d) = \u201ccalculated\u201d<\/p>\n

xv. RIGHT Function<\/h4>\n

RIGHT(string, num_chars)<\/p>\n

This String functions is the opposite of the LEFT function. It returns the characters from the end of a given string, the amount determined by the number of characters argument.<\/p>\n

Example:<\/strong>
\nRIGHT(\u201cNebraska\u201d, 6) = \u201cbraska\u201d<\/p>\n

xvi. RTRIM Function<\/h4>\n

RTRIM(string)<\/p>\n

The partner function to LTRIM. The RTRIM String functions returns the string with any trailing spaces removed.<\/p>\n

Example:<\/strong>
\nRTRIM(\u201cHarry \u201c) = \u201cHarry\u201d
\nRead about Joining Data in Tableau \u2013 Inner Join in detail<\/a><\/strong><\/p>\n

xvii. SPACE Function<\/h4>\n

SPACE(number)<\/p>\n

The SPACE function returns a string with the number of spaces defined by the number argument.<\/p>\n

Example:<\/strong>
\nSPACE(1) = \u201c \u201c<\/p>\n

xviii. STARTSWITH Function<\/h4>\n

STARTSWITH(string, substring)<\/p>\n

This is the opposite of the ENDSWITH function, and it returns a TRUE or FALSE result if the string starts with the substring.<\/p>\n

Example:<\/strong>
\nSTARTSWITH(\u201cMichigan\u201d, \u201cMic\u201d) = TRUE<\/p>\n

xix. TRIM Function<\/h4>\n

TRIM(string)<\/p>\n

The TRIM function removes any leading or trailing spaces from the string.<\/p>\n

Example:<\/strong>
\nTRIM(\u201c Harry \u201d) = \u201cHarry\u201d<\/p>\n

xx. UPPER Function<\/h4>\n

UPPER(string)<\/p>\n

Finally, the UPPER function works in opposite to the LOWER function. It takes all the characters in the string and converts them to uppercase characters.<\/p>\n

Example:<\/strong>
\nUPPER(\u201cnasa\u201d) = \u201cNASA\u201d
\nRead about\u00a0Dealing With Data Quality Problems In Tableau\u00a0<\/strong><\/a><\/p>\n

Conclusion<\/h3>\n

In this Tableau tutorial, we learned about various string functions in Tableau: ASCII Function, CHAR Function, CONTAINS Function, ENDSWITH Function, FIND Function, ISDATE Function, LEFT Function, LEN Function, LOWER Function, LTRIM Function, MAX Function, MID Function, MIN Function, REPLACE Function, RIGHT Function, RTRIM Function, SPACE Function, STARTSWITH Function, TRIM Function, UPPER Function with examples.<\/p>\n

Hope you find this article useful in enhancing your knowledge.<\/p>\n

Keep learning with DataFlair!!!<\/p>\n","protected":false},"excerpt":{"rendered":"

In this Tableau tutorial, we are going out to learn about string functions in tableau. We will discuss all twenty Tableau String Functions including ASCII, CHAR, CONTAINS and many other String functions with examples....<\/p>\n","protected":false},"author":5,"featured_media":10238,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[1169,2462,2947,4149,4710,7317,8199,8208,8421,8424,8607,8722,8727,11538,11607,11653,13018,13753,13902,13903,14442,14947,15180],"class_list":["post-10226","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-ascii-function","tag-char-function","tag-contains-function","tag-endswith-function","tag-find-function","tag-isdate-function","tag-left-function","tag-len-function","tag-lower-function","tag-ltrim-function","tag-max-function","tag-mid-function","tag-min-function","tag-replace-function","tag-right-function","tag-rtrim-function","tag-space-function","tag-startswith-function","tag-string-functions-in-tableau","tag-string-functions-with-examples","tag-tableau-string-function","tag-trim-function","tag-upper-function"],"yoast_head":"\nString Functions in Tableau - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn about String Functions in tableau. See its types like ASCII, CHAR, CONTAINS, ENDSWITH, FIND, ISDATE, LEFT, etc with examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"String Functions in Tableau - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn about String Functions in tableau. See its types like ASCII, CHAR, CONTAINS, ENDSWITH, FIND, ISDATE, LEFT, etc with examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-08T08:30:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-01T09:57:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/String-Function-in-Tableau-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"String Functions in Tableau - DataFlair","description":"Learn about String Functions in tableau. See its types like ASCII, CHAR, CONTAINS, ENDSWITH, FIND, ISDATE, LEFT, etc with examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/","og_locale":"en_US","og_type":"article","og_title":"String Functions in Tableau - DataFlair","og_description":"Learn about String Functions in tableau. See its types like ASCII, CHAR, CONTAINS, ENDSWITH, FIND, ISDATE, LEFT, etc with examples.","og_url":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-08T08:30:11+00:00","article_modified_time":"2025-03-01T09:57:37+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/String-Function-in-Tableau-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"String Functions in Tableau","datePublished":"2018-03-08T08:30:11+00:00","dateModified":"2025-03-01T09:57:37+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/"},"wordCount":972,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/String-Function-in-Tableau-01.jpg","keywords":["ASCII Function","CHAR Function","CONTAINS Function","ENDSWITH Function","FIND Function","ISDATE Function","LEFT Function","LEN Function","LOWER Function","LTRIM Function","MAX Function","MID Function","MIN Function","REPLACE Function","RIGHT Function","RTRIM Function","SPACE Function","STARTSWITH Function","String functions in Tableau","string functions with examples","tableau string function","TRIM Function","UPPER Function"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/","url":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/","name":"String Functions in Tableau - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/String-Function-in-Tableau-01.jpg","datePublished":"2018-03-08T08:30:11+00:00","dateModified":"2025-03-01T09:57:37+00:00","description":"Learn about String Functions in tableau. See its types like ASCII, CHAR, CONTAINS, ENDSWITH, FIND, ISDATE, LEFT, etc with examples.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/String-Function-in-Tableau-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/String-Function-in-Tableau-01.jpg","width":1200,"height":628,"caption":"String Function in Tableau"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/string-functions-in-tableau\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Tableau Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/tableau\/"},{"@type":"ListItem","position":3,"name":"String Functions in Tableau"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=10226"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10226\/revisions"}],"predecessor-version":[{"id":144367,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10226\/revisions\/144367"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/10238"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=10226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=10226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=10226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}