I have a field called Availability and the field values are like 98.32 % and I want them to be converted as decimal numbers like "0.9832" please help
An example event or two would be helpful, but perhaps this will get you started.
| eval Availability = round(tonumber(rtrim(Availability, "%")) / 100, 4)
An example event or two would be helpful, but perhaps this will get you started.
| eval Availability = round(tonumber(rtrim(Availability, "%")) / 100, 4)
Yes your answer perfectly works...
| makeresults
| eval value="98.32%"
| eval Availability = round(tonumber(rtrim(value, "%")) / 100, 4)
If your problem is resolved, then please click the "Accept as Solution" button to help future readers.