Table of contents
TOC
Collapse the table of content
Expand the table of content

Text.Insert

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

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

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

Arguments

ArgumentDescription
textThe text to insert into.
offsetThe index to insert at.
newTextThe 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"  
© 2018 Microsoft