Splunk Search

How to split multiple vlaues in single cell to new line in join search

gravi
Explorer

There few columns in the table that has multiple values in single line. I need them to be in separate/ newlines.

Current result preview: 4 12 22 87 2
Expected result view :
4
12
22
87
2

How do i achieve this?

0 Karma
1 Solution

to4kawa
Ultra Champion
| makeresults
| eval sample="4 12 22 87 2"
| makemv delim=" " sample

Hi, If you just want to separate it, you can use makemv command.

View solution in original post

to4kawa
Ultra Champion
| makeresults
| eval sample="4 12 22 87 2"
| makemv delim=" " sample

Hi, If you just want to separate it, you can use makemv command.

anthonymelita
Contributor

You can also use the split() eval command.
| makeresults
| eval sample="4 12 22 87 2"
| eval sample=split(sample, " ")
| mvexpand sample

0 Karma
Get Updates on the Splunk Community!

Splunk Education - Fast Start Program!

Welcome to Splunk Education! Splunk training programs are designed to enable you to get started quickly and ...

Five Subtly Different Ways of Adding Manual Instrumentation in Java

You can find the code of this example on GitHub here. Please feel free to star the repository to keep in ...

New Splunk APM Enhancements Help Troubleshoot Your MySQL and NoSQL Databases Faster

Splunk Observability has two new enhancements to make it quicker and easier to troubleshoot slow or frequently ...