REPLACE
Description
Returns a new string by replacing all case-sensitive occurrences of a target substring in the original string with a specified replacement.
Syntax
REPLACE(string, target, replacement) -> String
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| string | String | Yes | The original string. |
| target | String | Yes | The substring to replace. |
| replacement | String | Yes | The substring to insert in place of the target substring. |
Examples
REPLACE("PROD-ABC-123", "-", "_")
-- Returns "PROD_ABC_123".REPLACE(CaseDescription, "urgent", "important")
-- Replaces all occurrences of "urgent" with "important" in the field CaseDescription (case-sensitive).