Splitter.SplitTextByEachDelimiter
This function will return a new function that will separate a given text into a list of smaller texts, with each text being split at a specified delimiter in the order they appear.
Splitter.SplitTextByEachDelimiter(delimiters as list, optional quoteStyle as nullable number, optional startAtEnd as nullable logical) as functionThis function will return a new function that will separate a given text into a list of smaller texts, with each text being split at a specified delimiter in the order they appear.
Divide the given input string into separate parts using a comma followed by a semicolon. The separation process starts at the beginning of the input string.
Usage:
Power Query M
Splitter.SplitTextByEachDelimiter({",", ";"})("a,b;c,d")
Output:
{"a", "b", "c,d"}
Divide the given input string into separate parts using a comma followed by a semicolon. Treat quotes as regular characters and begin the separation process from the end of the input string.
Usage:
Power Query M
let
startAtEnd = true
in
Splitter.SplitTextByEachDelimiter({",", ";"}, QuoteStyle.None, startAtEnd)("a,""b;c"",d")
Output:
{"a,""b", "c""", "d"}