As i mentioned below prod column has multiple values and i want to split it based on \n next line command and get the output as mentioned in output image.
Current data:
Expected output:
Thanks in advance ..
Thanks for your input . As i mentioned Split not helped me.
I can able to achieve what i expected with below solution.
| makemv tokenizer="([^\r\n]+)(\r\n)?" Prod
| mvexpand Prod
🙂
| eval Prod=split(Prod,"
")
| mvexpand Prod
The split has the newline in quotes - hint: use <shift><return> to insert into search
@ITWhisperer
Sorry, I'm not able to follow you. Can you please give me an example query..
Thanks in advance ..
| eval Prod=split(Prod," ") | mvexpand Prod
If this is not working, can you share your search in the same way i.e. in a code block </>
Thanks for your input . As i mentioned Split not helped me.
I can able to achieve what i expected with below solution.
| makemv tokenizer="([^\r\n]+)(\r\n)?" Prod
| mvexpand Prod
🙂