Inserts
a string into another string.
SyntaxStuff(s1, n1, n2 [, s2 ])
Parameters
Parameter
|
Description
|
s1
|
The source string.
|
n1
|
The position in s1 to insert
the new string s2.
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.
|
ExamplesThe
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.
See
also Len.
|
Stuff("members-list@myweb.com", 0, 0, "cc:"
|
cc:members-list@myweb.com
|
|
|
|