String functions (LEFT, RIGHT, CONTAINS) in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to extract the first 3 characters from the field 'ProductName'.

Tableau

LEFT([ProductName], [1])

Drag options to blanks, or click blank then click option'

A3

B5

C1

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 returns an empty string.

Using 5 extracts too many characters.

The LEFT function extracts characters from the start of a string. Using 3 extracts the first three characters.

2fill in blank

medium

Complete the code to extract the last 4 characters from the field 'OrderID'.

Tableau

RIGHT([OrderID], [1])

Drag options to blanks, or click blank then click option'

A4

B2

C6

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using 2 extracts too few characters.

Using 6 extracts too many characters.

The RIGHT function extracts characters from the end of a string. Using 4 extracts the last four characters.

3fill in blank

hard

Fix the error in the code to check if 'CustomerName' contains the substring 'Smith'.

Tableau

CONTAINS([CustomerName], [1])

Drag options to blanks, or click blank then click option'

ASmith

C'Smith'

D"Smith"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes causes syntax errors.

Using single quotes is invalid in Tableau.

In Tableau, string literals must be enclosed in double quotes. So "Smith" is correct.

4fill in blank

hard

Fill both blanks to extract the first 2 characters from 'Category' and check if it contains 'El'.

Tableau

CONTAINS(LEFT([Category], [1]), [2])

Drag options to blanks, or click blank then click option'

A2

B3

C"El"

D"Ele"

Attempts:

3 left

💡 Hint

Common Mistakes

Using 3 extracts too many characters.

Not quoting the substring causes errors.

LEFT with 2 extracts first two characters. CONTAINS needs the substring "El" in quotes.

5fill in blank

hard

Fill both blanks to check if the last 3 characters of 'Region' contain 'USA'.

Tableau

CONTAINS(RIGHT([Region], [1]), [2])

Drag options to blanks, or click blank then click option'

A2

B"USA"

C3

D"US"

Attempts:

3 left

💡 Hint

Common Mistakes

Using 2 extracts too few characters.

Not quoting the substring causes errors.

RIGHT with 3 extracts last three characters. CONTAINS needs the substring "USA" in quotes.