TDS-C01 · Question #111
Which string function should you use to find a substring within a column and return a Boolean value?
The correct answer is C. CONTAINS. The CONTAINS function in Tableau is used to check if a specific substring exists within a string and returns a Boolean value (TRUE or FALSE). This function is ideal for identifying whether a particular sequence of characters is present within each value of a column. RTRIM…
Question
Which string function should you use to find a substring within a column and return a Boolean value?
Options
- ARTRIM
- BSPLIT
- CCONTAINS
- DENDSWITH
How the community answered
(29 responses)- A3% (1)
- B3% (1)
- C93% (27)
Explanation
The CONTAINS function in Tableau is used to check if a specific substring exists within a string and returns a Boolean value (TRUE or FALSE). This function is ideal for identifying whether a particular sequence of characters is present within each value of a column. RTRIM removes trailing spaces, SPLIT divides strings based on a delimiter, and ENDSWITH checks if a string ends with a specified substring, but none of these functions return a Boolean value indicating the presence of a substring.
Topics
Community Discussion
No community discussion yet for this question.