Replace

Replace Function

Replace replaces part of the specified text string, based on the number of characters specified, with a different specified text string.

Syntax

Replace (scalar StringValue, scalar StartIndex, scalar Length, scalar ReplacementText)

Arguments

Argument	Description
scalar StringValue	Original text string that will be manipulated
scalar StartIndex	Index position (counting from the left) of the first character to be replaced
scalar Length	Number of characters to be replaced
scalar ReplacementText	Text to be put into the original scalar text, starting at the position specified by the scalar StartPos

Examples:

Replace("How areU ?",8,1," You")

Replace a sub-string at a given index and of the given length with replacement string.