topic Re: Remove (quotes) from search command 'format' output in Splunk Dev

Remove (quotes) from search command 'format' output

RMurcia — Fri, 27 Oct 2023 00:46:19 GMT

Hello,

Your assistance is very much appreciated. I am performing a sub search and need the data to be recognized as a single set (statistic). For some reason the quotes are messing with the output on the subsearch.

IE:

<search><| dedup src_ip | rename src_ip as search | format > ......results in the following:

( ( "8.8.8.8" ) OR ( "1.1.1.1" ) OR ( "4.4.4.4" ) )

and I need the results from to be :

( ( 8.8.8.8 ) OR ( 1.1.1.1 ) OR ( 4.4.4.4 ) )

Thank you in advanced.

Re: Remove (quotes) from search command 'format' output

ITWhisperer — Fri, 27 Oct 2023 08:38:53 GMT

| eval search=replace(search, "\"", "")

Re: Remove (quotes) from search command 'format' output

RMurcia — Fri, 27 Oct 2023 16:26:34 GMT

Thank you very much. That did it! My approach was by regex and was not having any luck.