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?
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:
Remove special characters and add a semi colon in a word - Tableau
Mozell
4 months agoNikita
4 months agoSharee
5 months agoMozell
5 months agoGlen
6 months agoNikita
6 months ago