Replace

[this page | pdf]

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

-          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