Syntax
REPLACE(<string>; <number for start position>; <number of characters to replace>; <string replacement>)
Description
Replaces characters within a text string with a different text string.
Values less than zero for position or length cause an exception for actual data entry.
Examples
| String | Number of starting position | Number of characters to replace | String replacament | REPLACE returns |
|---|---|---|---|---|
| agfa | 1 | 2 | bbbb | abbbba |
| agfa | 1 | 10 | bb | abb |
| agfa | 2 | 1 | b | agba |