REPLACE

Syntax

REPLACE(<string>; <number for start position>; <number of characters to replace>; <string replacement>)

Description

Replaces characters within a text string with a different text string.
Values less than zero for position or length cause an exception for actual data entry.

Examples

StringNumber of starting positionNumber of characters to replaceString replacamentREPLACE returns
agfa12bbbbabbbba
agfa110bbabb
agfa21bagba