Substitute

Substitute Function

Substitutes the specified new text for all occurrences of specified old text in a text string.

Syntax

Substitute (scalar StringValue, scalar OldText, scalar NewText)

Arguments

Argument	Description
scalar StringValue	Original text string that will be manipulated
scalar OldText	Text in StringValue that will be replaced by NewText
scalar NewText	Text to be put into the original StringValue, in place of the OldText

Examples:

Substitute("Black N White","N","And")

Substitute N with And in the given string.