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?
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
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