Splunk Search

Can i have field names with spaces ?

rakesh_498115
Motivator

Hi ,

Can I have the fieldnames with spaces . i.e I have used the rename command in my search Query as follows..

my search ..| rename Prod_id as Product Details

This is throwing error..How can i use the rename command or is there any way to rename the fields with spaces included in the middle as shown above..

Please help..Thanks.

1 Solution

sdaniels
Splunk Employee
Splunk Employee

yes, you just need double quotes around the name.

... | rename Prod_id as "Product Details"

View solution in original post

luthfi49
Explorer

But I cannot calculate that field with space by eval command..
How can I calculate field with name containing space ?

0 Karma

rakesh_498115
Motivator

hi luthfi49,

for fields name with space , you can use in eval statement using single quote notation.

i.e. for example :

1) eval 'Product Details' = 'Product Details' + " Field "

2) eval 'user count' = 'user count' * 20

where "user count" is the field name.

thanks,
Rakesh.

grijhwani
Motivator

You don't. You leave the field name conversion until presentation time.

sdaniels
Splunk Employee
Splunk Employee

yes, you just need double quotes around the name.

... | rename Prod_id as "Product Details"
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...