INSERTSTRING function

Synopsis

This function inserts a string into another string.

Variations

INSERTSTRING(String, StartIndex, InsertedString)

Returns the first string with the second string inserted at the specified position.

Details | Examples | Details and examples

Parameters

String

Specifies the string to be modified.

Supported types: String.

StartIndex

Specifies the position in String at which to insert InsertedString.

Supported types: Numeric.

InsertedString

Specifies the string to insert into String.

Supported types: String.

Returns

Returned types: String.

Examples

1.	The following example inserts "Matrox Design " in front of "Assistant" and returns "Matrox Design Assistant". INSERTSTRING("Assistant", 1, "Matrox Design ")
2.	The following example inserts "Design " between the words "Matrox Assistant" and returns "Matrox Design Assistant" INSERTSTRING("Matrox Assistant", 8, "Design ")