REPLACE

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Replaces all occurrences of a substring with another substring.

1replace(<string>, <from>, <to>)

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

1SELECT replace('abcdefabcdef', 'cd', 'XX') AS result;

Returns 'abXXefabXXef'.

• String Types