Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Text functions > Replace function |
|
|
| Replace function |
| Format |
Replace(text;start;numberOfCharacters;replacementText) |
| Parameters |
| text - any text expression or text field |
| start - any numeric expression or field containing a number representing the starting position in text. |
| numberOfCharacters - any numeric expression or field containing a number representing the number of characters to remove from text. |
| replacementText - any text expression or field containing the text to replace in the original string. |
| Data type returned |
| text |
| Description |
| Examples |
| Replace("1234567";5;1;"X") returns 1234X67. |
| Replace("1234567";5;1;"XX") returns 1234XX67. |
| Replace("1234567";5;2;"X") returns 1234X7. |
| Replace("William";3;4;"NEW TEXT") returns WiNEW TEXTm. |
| Replace(PhoneNumber;1;3;"415") returns 415-555-9054, when the PhoneNumber field contains 408-555-9054. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Text functions > Replace function |
|
|
Next Page |
|