Replace

Syntax

Replace(Source: String, OldValue: String, NewValue: String)

Parameters

Source. Source string.

OldValue. Substring that must be replaced.

NewValue. Substring, with which the specified string must be replaced.

Description

It returns a string, in which all occurrences of the specified substring are replaced with the specified string.

Comments

If the substring is not found, the source string is not changed.

The method is case-sensitive.

Example

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