ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 76 - TDA-C01 discussion

Report
Export

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?

A.
TRIM
Answers
A.
TRIM
B.
CONTAINS
Answers
B.
CONTAINS
C.
REPLACE
Answers
C.
REPLACE
D.
SPLIT
Answers
D.
SPLIT
Suggested answer: C

Explanation:

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

asked 23/09/2024
Andrea DG
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first