Getting Data In

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

Path Finder

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!

0 Karma
1 Solution

Champion

Hi,

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

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

View solution in original post

Champion

Hi,

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

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

View solution in original post