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

[gemrose]

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

[gemrose]

Thank you @danielcj. your solution helped me a lot

[danielcj · Accepted solution]

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