Concat

The Concat() function strings together a list of texts.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Syntax

Concat(values)

Concat("text1", "text2") => "text1text2"

Concat(values, delimiter)

Concat(List("text1", "textpart2", "listitem3"), "#SEP#") => "text1#SEP#textpart2#SEP#listitem3"

Concat(values, delimiter, last_delimiter)

Concat(List("text1", "textpart2", "listitem3"), "#SEP#", "$LAST$") => "text1#SEP#textpart2$LAST$listitem3"

Parameters

Name
Type
Required
Description

values

text or list

☑️

a list of text

delimiter

text

is placed between the parts when they are joined together.

last_delimiter

text

is placed between the last two parts.

Last updated

Was this helpful?