Getting Data In

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

CarmineCalo
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

p_gurav
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

p_gurav
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

Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.