Splunk Search

How to omit leading zeros for all fields in a csv file coming from a Splunk forwarder?

Communicator

Hi,

I'm trying to omit the leading zeros for all fields in a csv file that comes from a splunk forwarder. Is there any way to do this WITHOUT going through every single field in every single row?

My data looks like this:

QUANTITY
000040
000051
000149
000004

and I would like it to look like...

QUANTITY
40
51
149
4
Tags (5)
0 Karma

Influencer
0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!