Function: Stuff

Description

Returns a string by replacing number of characters n in string s, starting at position p, using replacement string c.

Syntax

Stuff(s,p,n,c)

Arguments

s is the string you want to insert into, p is the starting position of the substring, n is the number of characters you wish to replace in s, and c is the substring.

Return value

This function returns a string.

Calculated field example

To change a value of Betty’s Music Store in the Customer field to Betty’s New Music Store use the following expression: Stuff(Customer,9,0,"New ")