Tableau Desktop Specialist — Question 57

In a dataset you have a string field named Name that contains unnecessary semicolons.

Which function should you use to remove the semicolons from the Name field?

Answer options

• A. TRIM
• B. REPLACE
• C. SPLIT
• D. CONTAINS

Correct answer: B

Explanation

The REPLACE function is specifically designed to substitute specific characters in a string with another character or an empty string, making it the correct choice for removing semicolons. The TRIM function only removes whitespace from the beginning and end of a string, while SPLIT divides a string into an array based on a delimiter and CONTAINS checks for the presence of a substring, neither of which would effectively remove semicolons.