Splunk Search

How to use stats list() but separate each value with ";"?

phamxuantung
Communicator

Hello,

I'm using stats list() to merge all my value into one field, but I want them to seperate with each other by ";" instead of space.

Example

USER_PHONE
123
456
789

 

When I use |stats list(USER_PHONE) the result I receive( in the csv that I output) was

123 456 789

The result that I want is 123;456;789

I try to use

... | rex mode=sed field=USER_PHONE "s/ /;/g"

But it have no effect, what should I do?

Labels (3)
0 Karma
1 Solution

Manasa_401
Communicator

Hello @phamxuantung 

you can also achieve it using mvjoin command.

|stats list(USER_PHONE) as phone
|eval phone=mvjoin(phone,";")

If this helps, karma would be appreciated.

Thanks,

Manasa

View solution in original post

Manasa_401
Communicator

Hello @phamxuantung 

you can also achieve it using mvjoin command.

|stats list(USER_PHONE) as phone
|eval phone=mvjoin(phone,";")

If this helps, karma would be appreciated.

Thanks,

Manasa

Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...