Splitter.SplitTextByDelimiter

The function returns a result by dividing the input text into separate parts based on the chosen separator.

Syntax

Splitter.SplitTextByDelimiter(delimiter as text, optional quoteStyle as nullable number) as function

About

The function returns a result by dividing the input text into separate parts based on the chosen separator.

Explanation

Separate the input data at each comma, but do not separate commas that are enclosed in quotation marks. For example: Input: "a,"b,c",d" Output: {"a", "b,c", "d"}