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

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

> James,
> Thank you for replying.
> 
> sample headers:
> Q.20C - Population May Include (Target)
> IRB#
> 
> Desired headers:
> Q20C_Population_May_Include_Target
> IRB_id

Try adding this argument where faster CSV opens the file:

  :header_converters => lambda { |h| h.tr(" ", "_").delete("^a-zA-Z0-9_") }

Hope that helps.

James Edward Gray II