Description | The |
Syntax | CONCAT( CONCAT( |
Output | text |
Variables
text1,text2,...: These are the text strings you want to concatenate. You can include multiple text strings separated by commas.list_variable: list variable; alternative text inputs.
Example 1
CONCAT(`Column 1`,`Column 2`,`Column 3`)
Column 1 | Column 2 | Column 3 | CONCAT |
Hello | , | world! | Hello,world! |
This | is a | test | Thisis atest |
Savant | is | amazing | Savantisamazing |
Example 2
CONCAT('How ','are ','you','?')
Column 1 | Column 2 | Column 3 | CONCAT |
Hello | , | world! | How are you? |
This | is a | test | How are you? |
Savant | is | amazing | How are you? |
Example 3
CONCAT(`Column 1`,'|Column 1')
Column 1 | Column 2 | Column 3 | CONCAT |
Hello | , | world! | Hello|Column 1 |
This | is a | test | This|Column 1 |
Savant | is | amazing | Savant|Column 1 |
Example 4
CONCAT(TO_TEXT(TODAY()),'_is_today.')
Column 1 | Column 2 | Column 3 | CONCAT |
Hello | , | world! | 2023-10-11_is_today. |
This | is a | test | 2023-10-11_is_today. |
Savant | is | amazing | 2023-10-11_is_today. |
Example 5
COALESCE(@list_variable)
List | CONCAT |
("a", "b", "c") | "a, b, c" |
