topic I am trying to create a multivalue where I should split the data during the pipe symbol. in Splunk Enterprise

I am trying to create a multivalue where I should split the data during the pipe symbol.

gemrose — Tue, 28 Jun 2022 06:12:21 GMT

For example if my data is

platform = "operational", task="draft||draft-published",jobstart="2021-06-27T15:46:08.34666||2021-06-27T18:46:08.70000, jobend="2021-06-28T12:86:08.37836||2021-06-28T18:46:08.70990"

I need in the below format. I tried makemv delim="||" task but this happens for only one field. Is there any other option available ?

platform	task	jobstart	jobend
operational	draft	2021-06-27T15:46:08.34666	2021-06-28T12:86:08.37836
operational	draft-published	2021-06-27T18:46:08.70000	2021-06-28T18:46:08.70990

Re: I am trying to create a multivalue where I should split the data during the pipe symbol.

danielcj — Tue, 28 Jun 2022 06:23:58 GMT

Hello,

Please try the following (The first two lines are just to mock your data as an example):

| makeresults | eval platform = "operational", task="draft||draft-published",jobstart="2021-06-27T15:46:08.34666||2021-06-27T18:46:08.70000", jobend="2021-06-28T12:86:08.37836||2021-06-28T18:46:08.70990" | eval jobstart = split(jobstart, "||"), task = split(task,"||"), jobend = split(jobend,"||") | eval multivalue = mvzip(mvzip(task, jobstart), jobend) | mvexpand multivalue | makemv multivalue delim="," | eval task = mvindex(multivalue, 0), jobstart = mvindex(multivalue, 1), jobend = mvindex(multivalue, -1) | table platform, task, jobstart, jobend

Re: I am trying to create a multivalue where I should split the data during the pipe symbol.

gemrose — Tue, 28 Jun 2022 11:57:53 GMT

Thank you @danielcj. your solution helped me a lot