REPLACE
Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
Replaces all occurrences of a substring with another substring.
<string>: The source string.<from>: The substring to find.<to>: The replacement substring.
Returns a text value with all occurrences replaced.
- Replaces all occurrences, not just the first.
- Replacement is case-sensitive.
Replace all occurrences of a substring.
Returns 'abXXefabXXef'.