topic Re: How do i delimit the multivalued fields in Splunk? in Getting Data In https://community.splunk.com/t5/Getting-Data-In/How-do-i-delimit-the-multivalued-fields-in-Splunk/m-p/491641#M83991 <P>Thanks @to4kawa it worked <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 01 Oct 2019 13:07:54 GMT Shashank_87 2019-10-01T13:07:54Z How do i delimit the multivalued fields in Splunk? https://community.splunk.com/t5/Getting-Data-In/How-do-i-delimit-the-multivalued-fields-in-Splunk/m-p/491639#M83989 <P>Hi, I have a search which produces a table and one of the column Username contains multiple values. They are kind of aliases for the same user. I need to delimit them using a comma separator. How do i achieve that please?</P> <P>Username<BR /> <A href="mailto:test1@gmail.com">test1@gmail.com</A><BR /> <A href="mailto:test2@gmail.com">test2@gmail.com</A><BR /> <A href="mailto:test3@gmail.com">test3@gmail.com</A><BR /> <A href="mailto:test4@gmail.com">test4@gmail.com</A></P> <P>I want something like this - <A href="mailto:test1@gmail.com">test1@gmail.com</A>, <A href="mailto:test2@gmail.com">test2@gmail.com</A>, <A href="mailto:test3@gmail.com">test3@gmail.com</A>, <A href="mailto:test4@gmail.com">test4@gmail.com</A></P> Tue, 01 Oct 2019 11:00:55 GMT https://community.splunk.com/t5/Getting-Data-In/How-do-i-delimit-the-multivalued-fields-in-Splunk/m-p/491639#M83989 Shashank_87 2019-10-01T11:00:55Z Re: How do i delimit the multivalued fields in Splunk? https://community.splunk.com/t5/Getting-Data-In/How-do-i-delimit-the-multivalued-fields-in-Splunk/m-p/491640#M83990 <PRE><CODE>|makeresults |eval username="test1@gmail.com#test2@gmail.com#test3@gmail.com#test4@gmail.com" |makemv delim="#" username |eval result=mvjoin(username,",") </CODE></PRE> <P>Hi, Try it.</P> Tue, 01 Oct 2019 11:25:11 GMT https://community.splunk.com/t5/Getting-Data-In/How-do-i-delimit-the-multivalued-fields-in-Splunk/m-p/491640#M83990 to4kawa 2019-10-01T11:25:11Z Re: How do i delimit the multivalued fields in Splunk? https://community.splunk.com/t5/Getting-Data-In/How-do-i-delimit-the-multivalued-fields-in-Splunk/m-p/491641#M83991 <P>Thanks @to4kawa it worked <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 01 Oct 2019 13:07:54 GMT https://community.splunk.com/t5/Getting-Data-In/How-do-i-delimit-the-multivalued-fields-in-Splunk/m-p/491641#M83991 Shashank_87 2019-10-01T13:07:54Z