Splitter.SplitTextByEachDelimiter

Syntax

Splitter.SplitTextByEachDelimiter(
    delimiters as list,
    optional quoteStyle as nullable number,
    optional startAtEnd as nullable logical
) as function

About

Returns a function that splits text into a list of text at each specified delimiter in sequence.

Example 1

Split the input by comma, then semicolon, starting from the beginning of the input.

Usage

Splitter.SplitTextByEachDelimiter({",", ";"})("a,b;c,d")

Output

{"a", "b", "c,d"}

Example 2

Split the input by comma, then semicolon, treating quotes like any other character and starting from the end of the input.

Usage

let
    startAtEnd = true
in
    Splitter.SplitTextByEachDelimiter({",", ";"}, QuoteStyle.None, startAtEnd)("a,""b;c"",d")

Output

{"a,""b", "c""", "d"}