ConcatWith (separator, text, ...)

Result Type: text

Definition: Concatenates the text strings passed as parameters, separating each by separator. This is equivalent to using the “+” operator.

Examples:  ConcatWith(", ", "Finn", "Conan", "", "Diarmaid")

returns “Finn, Conan, Diarmaid". Notice that no separator is used to separate an empty string from its neighbour.

ConcatWith(", ", ExpandDetail("Detail.ProductCode"))

returns “MW100, FD100, CONGCC" if there are three detail lines in the transaction containing those three product codes.