https://community.splunk.com/t5/Getting-Data-In/Should-I-reformat-my-csv-data-that-I-am-ingesting/m-p/611529#M105898 <P>Splunk will interpret "10us" as a string because it contains characters that don't belong in a number (sign, digits, decimal separator).&nbsp; To ensure Splunk treats numbers as numbers, remove any units before ingestion, if possible.&nbsp;&nbsp;</P> Thu, 01 Sep 2022 00:15:00 GMT richgalloway 2022-09-01T00:15:00Z https://community.splunk.com/t5/Getting-Data-In/Should-I-reformat-my-csv-data-that-I-am-ingesting/m-p/611528#M105897 <P>I have a csv file that is created by a shell script on a Linux server and runs every minute.&nbsp; I am running a forwarder on the server to send the data to splunk.&nbsp; The csv file has a header line containing the field names.&nbsp; Some of the data has units along with the number.&nbsp; What I mean is if the number is a percent, the number might look like "10%".&nbsp; If a number is measured in microseconds, the number might look like "10us".&nbsp; Is that the best way to ingest the data?&nbsp; Should I remove the units?&nbsp; Does Splunk see "10us" as a number?&nbsp;&nbsp; Thanks!</P> Wed, 31 Aug 2022 22:50:44 GMT https://community.splunk.com/t5/Getting-Data-In/Should-I-reformat-my-csv-data-that-I-am-ingesting/m-p/611528#M105897 bpiela 2022-08-31T22:50:44Z https://community.splunk.com/t5/Getting-Data-In/Should-I-reformat-my-csv-data-that-I-am-ingesting/m-p/611529#M105898 <P>Splunk will interpret "10us" as a string because it contains characters that don't belong in a number (sign, digits, decimal separator).&nbsp; To ensure Splunk treats numbers as numbers, remove any units before ingestion, if possible.&nbsp;&nbsp;</P> Thu, 01 Sep 2022 00:15:00 GMT https://community.splunk.com/t5/Getting-Data-In/Should-I-reformat-my-csv-data-that-I-am-ingesting/m-p/611529#M105898 richgalloway 2022-09-01T00:15:00Z