BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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?

Show Suggested Answer Hide 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


Contribute your Thoughts:

Mozell
5 months ago
Agreed. Easy choice, REPLACE it is!
upvoted 0 times
...
Nikita
5 months ago
TRIM and SPLIT don't seem relevant here. Good call,
upvoted 0 times
...
Sharee
5 months ago
Correct. It would replace all semicolons with an empty string.
upvoted 0 times
...
Mozell
5 months ago
Makes sense! REPLACE can target and remove specific characters, right?
upvoted 0 times
...
Glen
6 months ago
Yeah, but it's clear. I think the right function is REPLACE.
upvoted 0 times
...
Nikita
7 months ago
Such a specific question on string manipulation!
upvoted 0 times
...

Save Cancel