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

Splitter.SplitTextByDelimiter

Owen Duncan|Last Updated: 4/19/2018

About

Returns a function that will split text according to a delimiter.

Splitter.SplitTextByDelimiter(delimiter as text, optional quoteStyle as nullable number) as function  

Arguments

ArgumentDescription
delimiterThe delimiter character is used to identify at what points to split the string. The delimiter character is not included in the split values. A trailing delimiter character will yield an additional empty text value. The split values contain all characters between the delimiters. This function will always produce at least one value.
optional quoteStyleThe quoteStyle acts as described in Lines.FromText. By default, it is QuoteStyle.Csv.

Quote styles

  • QuoteStyle.None = 0;

  • QuoteStyle.Csv = 1;

© 2018 Microsoft