https://community.splunk.com/t5/Getting-Data-In/CSV-numbers-imported-as-strings-and-tonumber-returning-null/m-p/288491#M55137 <P>I'm a Splunk newbie.</P> <P>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</P> <P>I tryed to apply tonumber to convert the strings into number, but if the value is =! than zero, tonumber return a null value.</P> <P>Any suggestion?</P> <P>Tks!</P> Thu, 04 Jan 2018 22:43:28 GMT CarmineCalo 2018-01-04T22:43:28Z https://community.splunk.com/t5/Getting-Data-In/CSV-numbers-imported-as-strings-and-tonumber-returning-null/m-p/288491#M55137 <P>I'm a Splunk newbie.</P> <P>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</P> <P>I tryed to apply tonumber to convert the strings into number, but if the value is =! than zero, tonumber return a null value.</P> <P>Any suggestion?</P> <P>Tks!</P> Thu, 04 Jan 2018 22:43:28 GMT https://community.splunk.com/t5/Getting-Data-In/CSV-numbers-imported-as-strings-and-tonumber-returning-null/m-p/288491#M55137 CarmineCalo 2018-01-04T22:43:28Z https://community.splunk.com/t5/Getting-Data-In/CSV-numbers-imported-as-strings-and-tonumber-returning-null/m-p/288492#M55138 <P>Hi,</P> <P>try using <CODE>convert</CODE> command with auto() function. Please refer following document:</P> <P><A href="https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/SearchReference/Convert">https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/SearchReference/Convert</A> </P> Fri, 05 Jan 2018 05:12:21 GMT https://community.splunk.com/t5/Getting-Data-In/CSV-numbers-imported-as-strings-and-tonumber-returning-null/m-p/288492#M55138 p_gurav 2018-01-05T05:12:21Z