CSV numbers imported as strings... and tonumber() returning null

[CarmineCalo]

I'm a Splunk newbie.

I'm trying to import a CSV, including both strings and numbers, with source="csv": while strings are correctly imported and indexed, numbers are saved as strings as well. This make me crazy makins some simple stats

I tryed to apply tonumber to convert the strings into number, but if the value is =! than zero, tonumber return a null value.

Any suggestion?

Tks!

[p_gurav · Accepted solution]

Hi,

try using convert command with auto() function. Please refer following document:

https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/SearchReference/Convert