Hi, I have a search which produces a table and one of the column Username contains multiple values. They are kind of aliases for the same user. I need to delimit them using a comma separator. How do i achieve that please?
Username
[email protected]
[email protected]
[email protected]
[email protected]
I want something like this - [email protected], [email protected], [email protected], [email protected]
|makeresults
|eval username="[email protected]#[email protected]#[email protected]#[email protected]"
|makemv delim="#" username
|eval result=mvjoin(username,",")
Hi, Try it.
|makeresults
|eval username="[email protected]#[email protected]#[email protected]#[email protected]"
|makemv delim="#" username
|eval result=mvjoin(username,",")
Hi, Try it.
Thanks @to4kawa it worked 🙂