Splunk Search

Convert num not working

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

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

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

SplunkTrust
SplunkTrust

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

0 Karma
Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes
and swag!