Splunk Search

Convert num not working

venanciop
New Member

Convert does not work

search | convert num(quantity) as Quantity

The quantity field samples are: 1.0000
2.0000
9.0000
7.0000

0 Karma

tzitello_splunk
Splunk Employee
Splunk Employee

When I run convert on a field name, it does not convert the new field to numeric, it's alpha numeric. I'm running V 7.2.1

search| convert num(Samples.Sample.Depth) as meters

meters shows up with a instead of #. Suggestions?

0 Karma

koshyk
Super Champion

When you say it is NOT working, i'm not sure I understand. You provided quantity already as a number, so you won't see the difference

Try below to see the difference. You can see rounding works , sum works etc.

|makeresults | eval quantity="1.0000" | convert num(quantity) as Quantity| eval Quantity=round(Quantity,2)| eval sumQuantity=(1 + Quantity)
0 Karma

DalJeanis
SplunkTrust
SplunkTrust

Change that to | eval quantity="1.0000 " (non numeric) if you want to demonstrate any difference.

0 Karma
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Splunk is officially part of Cisco

Revolutionizing how our customers build resilience across their entire digital footprint.   Splunk ...

Splunk APM & RUM | Planned Maintenance March 26 - March 28, 2024

There will be planned maintenance for Splunk APM and RUM between March 26, 2024 and March 28, 2024 as ...