I'm looking for a way to numerically sort a multivalue field without expanding the field, sorting and then recombining. Essentially something like the following with a dedup. Before I post an idea I ...
See more...
I'm looking for a way to numerically sort a multivalue field without expanding the field, sorting and then recombining. Essentially something like the following with a dedup. Before I post an idea I wanted to see if anyone has any ideas on how to accomplish this. Essentially I'm trying to find a way to run conversion functions from here against a multivalue field, ideally on the same eval. | makeresults
| eval line_list=split("4,3,2,1,7,2,21,9,12,19,7",",")
| eval line_list=mvsort(mvdedup(tonumber(line_list))) Instead I have to do this: | makeresults
| eval line_list=split("4,3,2,1,7,2,21,9,12,19,7",",")
| mvexpand line_list
| eval line_list=tonumber(line_list)
| sort line_list
| dedup line_list
| mvcombine line_list