Purpose

CHANGE replaces all occurrences of a sub-string (within the source string) with the replacement sub-string.
 

Syntax

variable = CHANGE (operand1,operand2,operand 3)
 

Operation

operand1 is any valid alphanumeric string
operand2 is any valid alphanumeric literal or variable specifying the sub-string of characters within operand 1 to be replaced
operand 3 is the sub-string of characters to replace those specified in operand 2 
variable is the resulting string
 

Remarks
 

Example
 

$A = CHANGE("The:Quick:Brown",":"," seriously "),

....................................gives $A =  "The seriously Quick seriously Brown" to $A

$A = CHANGE("The:Quick:Brown",":",""),

....................................gives $A = "TheQuickBrown"