csv input file column name contains percent sign

[grywiner51]

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.

[richgalloway · Accepted solution]

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

[grywiner51]

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.