topic csv input file column name contains percent sign in Getting Data In

csv input file column name contains percent sign

grywiner51 — Wed, 15 Jul 2020 22:17:09 GMT

The .csv file that I am using as input has a column name that begins with a percent sign ("% Complete"). I just noticed that the indexer has been ignoring this column. Even when I updated the sourcetype to use the first row as column names and it recognized the existence of the column (renamed it as simply "Complete"), it still won't show up as available to use in reports / dashboards. Is there a way to get around this that does not involve changing the column name? Thanks.

Re: csv input file column name contains percent sign

richgalloway — Thu, 16 Jul 2020 00:42:26 GMT

Percent signs are not allowed in field names. Let Splunk strip out the '%' and use rename in dashboard and reports to add it in.

Re: csv input file column name contains percent sign

grywiner51 — Mon, 20 Jul 2020 18:10:33 GMT

Splunk wasn't doing that. It was making believe that the field didn't exist. But after reading your answer I began playing around with the import settings. Once I changed the Delimiter Setting from Auto to specify field names on Line 1 Splunk did its thing. Thanks.