Splunk Search

How to remove leading zeros from a numeric value?

pradeepkumarg
Influencer

I have a field on which I am doing ltrim function to remove the leading 0's


eval fieldA = ltrim(fieldA ,"0")

000000104020471991 is being converted to 1.0402e+11. 

How can I get just 104020471991 ?

Tags (3)
1 Solution

icyfeverr
Path Finder

try this:

eval fieldA=ltrim(tostring(fieldA),"0")

View solution in original post

icyfeverr
Path Finder

try this:

eval fieldA=ltrim(tostring(fieldA),"0")

pradeepkumarg
Influencer

Thank you.. overlooked tostring() function 🙂

0 Karma
Get Updates on the Splunk Community!

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...

From Alert to Resolution: How Splunk Observability Helps SREs Navigate Critical ...

It's 3:17 AM, and your phone buzzes with an urgent alert. Wire transfer processing times have spiked, and ...