CONCAT ()
- Jim Roldan
- Pedro Jose Sanchez Luling
- Alfredo Delli Bovi (Unlicensed)
CONCAT(separator, text [, text, text...]) |
API Version | All |
|---|
Concatenates a list of strings
Creates a concatenation of all the strings passed as parameters separating them with the string provided in the parameter separator.
The concatenation takes into account all strings passed, even if they are empty. If you want to ignore empty values, use CONCAT_NON_EMPTY() formula.
Input Parameters
Parameter | Type | Default | Required | Description |
|---|---|---|---|---|
|
| Yes | String that will be used as separator when concatenating the strings
| |
| String/Array |
| Yes | This parameter can be repeated as many times as necessary. The list of text parameters provided will be concatenated using the separator specified. It is also possible to pass an array as parameter. In that case, each item of the array will be included in the final concatenated string |
Execution
Always. Calculated on-the-fly whenever an ITEM of a FORM is changed (by means of form_set_answer(), or when the FORM is opened
Examples
Formula | Description |
|---|---|
CONCAT(“-”, “1”, ““, “3”) | The evaluation of this formula will return: “1--3” Note that the empty string is also included in the concatenation. If you want to ignore empty values, use CONCAT_NON_EMPTY() formula. |
CONCAT(“-”, “1”, [“a”, ”b”],“2”) | The evaluation of this formula will return: “1-a-b-2” In this example we have passed an array as one of the parameters. The final concatenated string contains the items of the array |