| description | title |
|---|---|
Learn more about: Splitter.SplitTextByEachDelimiter |
Splitter.SplitTextByEachDelimiter |
Splitter.SplitTextByEachDelimiter(delimiters as list, optional quoteStyle as nullable number, optional startAtEnd as nullable logical) as function
Returns a function that splits text into a list of text at each specified delimiter in sequence.
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"}
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"}