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!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...