Replace(Source: String, OldValue: String, NewValue: String)
Source. Source string.
OldValue. Substring that must be replaced.
NewValue. Substring, with which the specified string must be replaced.
It returns a string, in which all occurrences of the specified substring are replaced with the specified string.
If the substring is not found, the source string is not changed.
The method is case-sensitive.
Formula | Result | Application |
= Replace("Version 8.5", "8.5", "9.0") | Version 9.0 |
Expressions can be used in model formulas of modeling container, in formulas of time series database calculated series, in formulas of the modeling container that is a child one for time series database in expression editor. |
= Replace("Version 8.5", "version", "Edition") | Version 8.5 |
See also:
Functions Available in Expression Editor │ Text Functions │ String.Replace