From: James Edward Gray II <james@...>
Date: 2009-11-18T01:32:19+09:00
Subject: Re: Special characters in csv header using fastercsv

On Nov 17, 2009, at 10:24 AM, John Mcleod wrote:

> Hello all,

Hello.

> First, I read a csv file (approx. 6,000 lines). This file comes from a
> different department, so I have no control over the headers.
> 
> Second, while reading or parsing the file, the rows are inputted into a
> database.
> 
> My problem is my database columns can not have special characters, but
> the csv headers have the special characters.
> 
> Is there a way to remove the special characters before inserting in
> database?

Sure.  FasterCSV support header_converters that can transform your headers in any way that you need.  Can you show a sample header and what you would like it to become?

James Edward Gray II