Getting Data In

How do i delimit the multivalued fields in Splunk?

Shashank_87
Explorer

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
test1@gmail.com
test2@gmail.com
test3@gmail.com
test4@gmail.com

I want something like this - test1@gmail.com, test2@gmail.com, test3@gmail.com, test4@gmail.com

0 Karma
1 Solution

to4kawa
Ultra Champion
|makeresults
|eval username="test1@gmail.com#test2@gmail.com#test3@gmail.com#test4@gmail.com"
|makemv delim="#" username
|eval result=mvjoin(username,",")

Hi, Try it.

View solution in original post

0 Karma

to4kawa
Ultra Champion
|makeresults
|eval username="test1@gmail.com#test2@gmail.com#test3@gmail.com#test4@gmail.com"
|makemv delim="#" username
|eval result=mvjoin(username,",")

Hi, Try it.

0 Karma

Shashank_87
Explorer

Thanks @to4kawa it worked 🙂

0 Karma
Get Updates on the Splunk Community!

What’s new on Splunk Lantern in August

This month’s Splunk Lantern update gives you the low-down on all of the articles we’ve published over the past ...

Welcome to the Future of Data Search & Exploration

You have more data coming at you than ever before. Over the next five years, the total amount of digital data ...

This Week's Community Digest - Splunk Community Happenings [8.3.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...