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)