Text.Insert

About

Returns a text value with newValue inserted into a text value starting at a zero-based offset.

Syntax

Text.Insert(text as nullable text, offset as number, newText as text) as nullable text  

Arguments

Argument Description
text The text to insert into.
offset The index to insert at.
newText The new text to insert.

Remark

  • If offset is less than zero or more than the length of a text value, an Expression.Error is thrown.

Example

Text.Insert("abcdef",2,"X") equals "abXcdef"