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

[phamxuantung]

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?

[Manasa_401 · Accepted solution]

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