https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125307#M33863 <P>How to use delim with stats? Multivalued fields generated after using list() in stats is resulting in space-separated values to be emailed to me in a scheduled search rather than them appearing on a new line. Will delim be helpful? If not, is there any other way? </P> Mon, 30 Jun 2014 21:45:42 GMT adityainamdar89 2014-06-30T21:45:42Z https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125307#M33863 <P>How to use delim with stats? Multivalued fields generated after using list() in stats is resulting in space-separated values to be emailed to me in a scheduled search rather than them appearing on a new line. Will delim be helpful? If not, is there any other way? </P> Mon, 30 Jun 2014 21:45:42 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125307#M33863 adityainamdar89 2014-06-30T21:45:42Z https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125308#M33864 <P>You can for example set <CODE>delim=";"</CODE> and your values will be separated by a semicolon... however, I haven't gotten a newline to work.</P> Tue, 01 Jul 2014 09:07:51 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125308#M33864 martin_mueller 2014-07-01T09:07:51Z https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125309#M33865 <P>I found this solution to my problem:</P> <P>| stats delim=":" list(XYZ) as XYZ BY CRITERIA <BR /> | rex mode=sed field=XYZ "s/:/\n/g"</P> <P>This gives you the results on new lines in the table emailed from splunk.</P> Tue, 01 Jul 2014 19:09:22 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125309#M33865 adityainamdar89 2014-07-01T19:09:22Z https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125310#M33866 <P>Thanks..I figured out the solution <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 01 Jul 2014 19:13:25 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125310#M33866 adityainamdar89 2014-07-01T19:13:25Z https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125311#M33867 <P>Glad you found a solution @adityainamdar89 <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Be sure to accept your answer (clicking on the check mark to the left of this answer) so other users with similar issues will look to this post for help. You also get some karma points too!</P> Tue, 01 Jul 2014 20:34:54 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-delim-with-stats/m-p/125311#M33867 ppablo 2014-07-01T20:34:54Z