topic Re: How do I cut the designated decimal place based on numerical number? in Splunk Search

How do I cut the designated decimal place based on numerical number?

syusjk6 — Mon, 24 Dec 2012 05:50:09 GMT

Say, I have come up with the result value, 3.9999.

I want the rest of decimal places gone after the second decimal place as in 3.9999.
What would you suggest?

FYI, I don't want "round(3.9999, 2).'

Re: How do I cut the designated decimal place based on numerical number?

syusjk6 — Mon, 24 Dec 2012 05:54:00 GMT

For example,
I want 3.9999 to be cut into 3.99, not into 4.00, or
I want 3.1634 to be cut into 3.16, not into 3.20.

Re: How do I cut the designated decimal place based on numerical number?

cyue_splunk — Mon, 28 Sep 2020 13:00:44 GMT

I don't know if there is a command to directly provide result as you required. But I think you can do sth like this:

| eval value_new=round(floor(value_old*100)/100,2)

Re: How do I cut the designated decimal place based on numerical number?

jonuwz — Mon, 24 Dec 2012 08:40:28 GMT

you could use a regex

... | rex field=value (?<value>^-?\d+\.\d{2})\d+$

Re: How do I cut the designated decimal place based on numerical number?

jonuwz — Thu, 27 Dec 2012 18:51:37 GMT

syusjk6 - thank you for assigning me rep 🙂
The usual way is to click on the grey up arrow to the left of the answer if it helped you out. And if it answered your question completely, accept the answer.

Re: How do I cut the designated decimal place based on numerical number?

syusjk6 — Wed, 16 Jan 2013 23:59:20 GMT

Thanks. This helped.