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!

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...