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!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...