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 formula editor. |
| = Replace("Version 8.5", "version", "Edition") | Version 8.5 |
See also:
Functions Available in Expression Editor │ Text Functions │ String.Replace