Replace() returns a string after replacing all occurrences of a given substring within the input string with another substring. The function is non-recursive and works from left to right.
Syntax:
Replace(text, from_str, to_str)
Return data type: string
Arguments:
| Argument | Description |
|---|---|
| text | The original string. |
| from_str | A string which may occur one or more times within the input string text. |
| to_str | The string that will replace all occurrences of from_str within the string text. |
Examples and results:
| Example | Result |
|---|---|
| Replace('abccde','cc','xyz') | Returns 'abxyzde' |
