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.
yes, you just need double quotes around the name.
... | rename Prod_id as "Product Details"
But I cannot calculate that field with space by eval command..
How can I calculate field with name containing space ?
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.
You don't. You leave the field name conversion until presentation time.
yes, you just need double quotes around the name.
... | rename Prod_id as "Product Details"