CONCAT
- Charles Bishop (Deactivated)
Owned by Charles Bishop (Deactivated)
Jan 30, 2018
Loading data...
Syntax
CONCAT(<any>;Â <any>;Â <any>Â Â ..)
Description
Concatenates several items to one string item. Items in the function are separated by a semicolon.Â
Supports more than 255 arguments.
Any data type other than the LIST type can be used with the CONCAT function.
To add elements to a list, Â use the ADD function. To connect multiple lists into a single list, Â use the + operator.
Examples
Connecting columns
CONCAT(#Data!Column1;#Data!Column2)
| Column1 | Column2 | CONCAT returns |
|---|---|---|
| A | B | AB |
| Mark | Jones | MarkJones |
| Product | 6 | Product6 |
Adding specific values
CONCAT(#Data!Column1;"B")
| Column1 | Added value | CONCAT returns |
|---|---|---|
| 123 | "B" | 123B |
CONCAT(#Data!Column1;" ";"B")
| Column1 | Added value | Added value | CONCAT returns |
|---|---|---|---|
| 123 | " " | "B" | 123 B |
CONCAT(#Data!Column1;" ";#Data!Column2;" ";"B")
| Column1 | Added value | Column2 | Added value | Added value | CONCAT returns |
|---|---|---|---|---|---|
| 123 | " " | Product | " " | "B" | 123 Product B |