If
n1
is
less than one, the function assumes the first character position.
If
n1
is greater than length of
s1
, the
function assumes the last character position.
n2
The number of characters to delete from
string
s1
, starting at character position
n1
.
If
n2
is
less than or equal to 0, the function assumes 0 characters.
s2
(Optional)
The string to insert into
s1
.
If
you do not include a value for
s2
, the function
uses the empty string.
Examples
The
following expressions are examples that use the
Stuff
function:
Expression
Returns
Stuff("TonyBlue", 5, 0, " ")
Tony Blue
Stuff("ABCDEFGH", 4, 2)
ABCFGH
Stuff(Address[0], Len(Address[0]), 0, "Street")
This adds the word
Street
onto
the end of the first occurrence of
Address.