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

Text.Split

Owen Duncan|Last Updated: 4/19/2018

About

Returns a list containing parts of a text value that are delimited by a separator text value.

Text.Split(string as text, separator as text) as list  

Arguments

ArgumentDescription
stringThe string to parse.
separatorA delimiter value.

Remarks

  • If two delimiter values are adjacent, or appear at the beginning or end of the text value, the corresponding element in the returned list is an empty text value.

  • If the text value does not contain separator, the returned array consists of a single item containing the original text value.

© 2018 Microsoft