REPLACE
Substitute characters in a string
Example Usage
REPLACE("ABC123", "12", "789") -> "ABC7893"
Overview
Function signature
REPLACE(value, searchfor, replacewith)
Category
String
Return data type
string
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
value | string | Source string to search on | |
searchfor | string | Characters or phrase to search for | |
replacewith | string | Characters or phrase to substitute in |