Splitter.SplitTextByEachDelimiter

Syntax

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

About

返回一个函数，该函数按顺序将文本拆分为每个指定分隔符处的文本列表。

示例 1

按逗号拆分输入，然后从输入开头开始分号。

用法

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

输出

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

示例 2

用逗号拆分输入，然后用分号，像对待任何其他字符一样对待引号，并从输入的末尾开始。

用法

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

输出

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