topic Re: How can I add quotes and comma to a multivalued field? in Splunk Search

How can I add quotes and comma to a multivalued field?

Woodpecker — Thu, 08 Dec 2022 12:41:13 GMT

HI,

I have a multivalued field with values as
A
B
C
I want it to be replaced as 'A','B','C' . I tried to do it with eval mvjoin, but the first and last values misses the quote like this
A','B','C

SPL used is:

index=* sourcetype=* host=abc NAME IN ("*A*","*B*","*C*") |stats values(NAME) as NAME by host | eval NAME = mvjoin(NAME,"','")

Any help would be appreciated, thankyou

Re: How can I add quotes and comma to a multivalued field?

StefanoA — Thu, 08 Dec 2022 13:13:27 GMT

You're almost there

Modify the last eval with

| eval NAME = "'".mvjoin(NAME,"','")."'"

Re: How can I add quotes and comma to a multivalued field?

ITWhisperer — Thu, 08 Dec 2022 13:14:39 GMT

| eval NAME="'".mvjoin(NAME,"','")."'"

Re: How can I add quotes and comma to a multivalued field?

Woodpecker — Fri, 09 Dec 2022 06:17:36 GMT

This works! thankyou

Re: How can I add quotes and comma to a multivalued field?

Woodpecker — Fri, 09 Dec 2022 06:29:13 GMT

Hi,

Is it possible to get values like this: (ie., double quotes instead of single quotes)

"A","B","C"

Re: How can I add quotes and comma to a multivalued field?

Woodpecker — Fri, 09 Dec 2022 06:40:01 GMT

This works for me

| eval NAME = "\"".mvjoin(NAME,"\",\"")."\""