Splunk Enterprise

Remove spaces from all field names

aa70627
Communicator

Is there any quick way to remove specific at the beginning and end of all fields names? For example i am looking looking to remove all spaces to the left and right of all field names. How do i do this?

0 Karma

ifathklein
Engager

foreach * [ eval newFieldName=replace("<<FIELD>>", "\s+", "_"),  {newFieldName}='<<FIELD>>'  ] | fields - "* *", newFieldName

romedome
Path Finder

Very smart! Thanks!

0 Karma

niketn
Legend

@aa70627, you are possibly looking for the trim() evaluation function. You can also use replace() evaluation function to replace regular expression based match pattern from string.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

xpac
SplunkTrust
SplunkTrust

Can you show an example of what you have right now, and how you would like it to be?

0 Karma
Get Updates on the Splunk Community!

Developer Spotlight with Brett Adams

In our third Spotlight feature, we're excited to shine a light on Brett—a Splunk consultant, innovative ...

Index This | What can you do to make 55,555 equal 500?

April 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Say goodbye to manually analyzing phishing and malware threats with Splunk Attack ...

In today’s evolving threat landscape, we understand you’re constantly bombarded with phishing and malware ...