Replace
[this page | pdf]
Function Description
Returns a string derived from InputString in which
occurrences of a specified substring (FindString) are replaced by ReplacementString.
The other replacements only start from the StartingPosition character
and only the first NumberOfTimesToReplace are replaced (unless NumberOfTimesToReplace
= -1 in which case all relevant occurrences are replaced).
If IsCaseSensitive is true then function uses
‘binary’ comparison so differentiates between upper and lower case letters,
otherwise uses ‘text’ comparison and so does not differentiate between upper
and lower case letters.
NAVIGATION LINKS
Contents | Prev | Next
Output type / Parameter details
Output type: String
| Parameter Name | Variable Type | Description |
| InputString | String | Input string to be modified |
| FindString | String | String to be replaced |
| ReplacementString | String | String to be inserted |
| StartingPosition | Integer | Starting position from where comparisons begin |
| NumberOfTimesToReplace | Integer | Max number of times to carry out replacement (no limit if -1) |
| IsCaseSensitive | Boolean | Flag to indicate whether to do a case sensitive comparison |
Links to:
-
Interactively run function
-
Interactive instructions
-
Example calculation
-
Output type / Parameter details
-
Illustrative spreadsheet
-
Other String functions
-
Computation units used
Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement