mvjoin()

Table of Contents

Definition

mvjoin() takes a multivalue column and a string delimiter as arguments. This function joins multivalue column values into a single string column using the string delimiter.

Syntax
...| eval n=mvjoin(<column-reference>, "<string-delimiter>")

Examples

The following example adds a string delimiter "OR" to separate pet names in a multivalue column.

| makeresults
| eval pets=mvappend("Bella", "Jontti", "Moto")
| eval joined=mvjoin('pets'," OR ")
Screenshot of the previous example’s result

Further Reading