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.SplitTextByAnyDelimiter(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 any of the specified delimiters.
Example 1
Split the input by comma or semicolon, ignoring quotes and quoted delimiters and starting from the beginning of the input.
Usage
Splitter.SplitTextByAnyDelimiter({",", ";"}, QuoteStyle.Csv)("a,b;""c,d;e"",f")
Output
{"a", "b", "c,d;e", "f"}
Example 2
Split the input by comma or semicolon, ignoring quotes and quoted delimiters and starting from the end of the input.
Usage
let
startAtEnd = true
in
Splitter.SplitTextByAnyDelimiter({",", ";"}, QuoteStyle.Csv, startAtEnd)("a,""b;c,d")
Output
{"a,b", "c", "d"}