generate a comma delimited list

[royimad]

I have the following search
sourcetype = "DevicesInfo" | stats values(DeviceSubType) as series | makemv delim="," series | fields series
but the result string "series" is not comma seperated.
Does anyone have an idea why the result i'm getting is not comma seperated?
Thanks!

[Ayn]

You should read the docs.

makemv is used for creating a multivalued field out of a comma-separated string, not the other way around. To do the opposite, use eval's function mvjoin.

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Makemv
http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/CommonEvalFunctions