Search

 

Module: Editor

Version: 2.2.1 +

Type: String

Category: Text

 

Description

The formula 'Substitute' replaces existing text with new text in a text string.

Parameters

Text:                     this is the text string in which you want to substitute characters.

Old_text:               this is the existing text you want to replace. If the input of 'Old_text' does not match the input of 'Text', the formula 'Substitution' will not replace the text.

New_text:              this is the text you want to replace 'Old_text' with.

Example

Description

In the following example you can see how the formula 'Substitute' works.

Values parameters

Text:                     Dear Mr.

Old_text:               Mr.

New_text:              Ms.

Result

Output:                 Dear Ms.

Feedback

If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.

Updated: 2014-09-25