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'.