Splunk Search

splunk queries to insert special characters in field values

splunker12er
Motivator

How to insert apostrophes in all field values

Results:

group         count
10.243.200.14   1
10.243.200.29   1
10.243.200.67   1

expected o/p:

 group          count
"10.243.200.14" 1
"10.243.200.29" 1
"10.243.200.67" 1
Tags (1)
0 Karma

woodcock
Esteemed Legend

There are a kazillion ways to do it:

... | rex mode=sed field=group "s/(.*)/\"\1\"/"
0 Karma

fdi01
Motivator

see answers of jeffland above it ok or
you can also try like :

....| eval group="\""+group+"\""

jeffland
SplunkTrust
SplunkTrust

If you want them to be in the data (i.e. for later csv export or further calculations), you can add quotes like this:

your search | eval group="\"".group."\""

Keep in mind that this changes the actual value of your field. If you simply want to display quotes around your fields in the table, use fieldformat:

your search | fieldformat group="\"".group."\""

This will only change how your data is rendered in the table, not the actual field values.

Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...