Splunk Search

Calculate number of decimals for each record in field?

DPOIRE
Path Finder

Field = 1.123456789

Field = 14.123456

Field = 3.1234567

I need to run a query that will return the number of decimals for each record in Field.

Expected Result:

9

6

7

Labels (1)
Tags (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| eval decimal=len(mvindex(split(Field,"."),1))

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| eval decimal=len(mvindex(split(Field,"."),1))

DPOIRE
Path Finder

Exactly was I was looking for.
Thanks!

0 Karma
Get Updates on the Splunk Community!

Announcing the Expansion of the Splunk Academic Alliance Program

The Splunk Community is more than just an online forum — it’s a network of passionate users, administrators, ...

Learn Splunk Insider Insights, Do More With Gen AI, & Find 20+ New Use Cases You Can ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Buttercup Games: Further Dashboarding Techniques (Part 7)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...