strcat()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Concatenates between 1 and 64 arguments.
Syntax
strcat(argument1, argument2 [, argument3 ... ])
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| argument1 ... argumentN | scalar | ✔️ | The expressions to concatenate. |
Note
If the arguments aren't of string type, they'll be forcibly converted to string.
Returns
The arguments concatenated to a single string.
Examples
Concatenated string
The following example uses the strcat() function to concatenate the strings provided to form the string, "hello world." The results are assigned to the variable str.
print str = strcat("hello", " ", "world")
Output
| str |
|---|
| hello world |
Concatenated multi-line string
The following example uses the strcat() function to create a concatenated multi-line string which is saved to the variable, MultiLineString. It uses the newline character to break the string into new lines.
print MultiLineString = strcat("Line 1\n", "Line 2\n", "Line 3")
Output
The results show the expanded row view with the multiline string.
| MultiLineString |
|---|
| 1. "MultiLineString": Line 1 2. Line 2 3. Line 3 |