Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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"}