concat

Learn more about the Cortex Query Language concat() function joins multiple strings into a single string.

Syntax

concat (<string1>, <string2>, ...)

Description

The concat() function joins multiple strings into a single string. When using the concat() function with multiple fields and any of the fields have a null/empty value, the function returns empty.

Example

Display the first non-NULL action_boot_time field value. In a second column called abt_string, use the concat() function to prepend "str: " to the value, and then display it.

dataset = xdr_data 
| fields action_boot_time as abt 
| filter abt != null 
| alter abt_string = concat("str: ", to_string(abt)) 
| limit 1