Splunk Search

How to get only 2 decimal values without rounding?

shankarananthth
Explorer

I have the value in the field as mentioned below ..

data
1234.456
1256.445
12.456
156.446

I need the output as mentioned below.
Kindly help me to achieve it.

data
1234.45
1256.44
12.45
156.44

Thanks in advance.

Tags (2)
0 Karma

somesoni2
Revered Legend

Try this

your base search | eval data=replace(data,"(\d+\.\d\d)\d*","\1")
0 Karma

sundareshr
Legend

Try using regex. This should work (change data to fieldname of choice)

... | rex "(?<data>\d+\.\d{0,2})" 
0 Karma
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...