Edit

ConcatWith (separator, text, ...)

Result Type: text

Definition: Concatenates the text strings passed as parameters, separating each by separator. This is similar 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.

ConcatAllWith Count