Tableau Exam TDA-C01 Topic 3 Question 41 Discussion

Actual exam question for Tableau's TDA-C01 exam

Question #: 41
Topic #: 3

[All TDA-C01 Questions]

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?

ATRIM

BCONTAINS

CREPLACE

DSPLIT

Show Suggested Answer

Suggested Answer: C

The REPLACE function is used to replace all occurrences of a substring within a string with another substring. In this case, it can be used to remove the semicolons from the Name field by replacing them with an empty string. For example, REPLACE (''John;Doe'', '';'', '''') = ''JohnDoe''.Reference:The information is based on the following sources:

String Functions - Tableau

Remove special characters and add a semi colon in a word - Tableau

by Pansy at May 10, 2024, 10:08 AM

Limited Time Offer

25%

7 months ago

Such a specific question on string manipulation!

upvoted 0 times

...