Replace

Mon 01 January 2018

Syntax

Replace(oldtext, start, num_chars, newtext)

Description

Use the Replace function to replace a specified number of characters in a string.

Parameters

Field or Control

Definition

oldtext

A String value, part of which is to be replaced.

start

A Number designating the position in oldtext from which to start replacing characters.

num_chars

A Number, specifying how many characters to replace in oldtext .

newtext

A String value that replaces num_chars characters.

Returns

Returns a String value in which specific characters in oldtext are replaced with newtext .