JOIN_STRINGS
Description
JOIN_STRINGS
is a row function that returns a TEXT
by concatenating (combining together) the results of multiple TEXT
values with the separator in between each non-null value.Syntax
JOIN_STRINGS
(separator
,value_expression
, [value_expression
][,...])Return Value
Returns one value per row of type
TEXT
.Input Parameters
- separator
- Required. A field name of typeTEXT, a literal string, or an expression that returns aTEXT.
- value_expression
- At least one required. A field name of any type, a literal string or number, or an expression that returns any value.
Examples
Combine the values of the
month
, day
, and year
fields into a single date field formatted as MM/DD/YYYY
.JOIN_STRINGS("/", [month], [day], [year])
The following expression returns NULL:
JOIN_STRINGS("+", NULL, NULL, NULL)
The following expression returns
a+b
:JOIN_STRINGS("+", "a", "b", NULL)