On 1/29/07, ChrisH [email protected] wrote:
On Jan 29, 11:22 am, “John K.” [email protected] wrote:
I want to create an excel file from data I get from my DB but since
some of my fields contain commas in them I was hoping I can use
CSV::Writer but instead of having the default of commas seperate data
I could use tabs? Any have any suggestions on what the sexiest way to
do this is?
it is okay to have commas in CSV fields.
%w[ foo,bar baz ].to_csv
CSV in the stdlib should handle this correctly as well.
So that having been said, possibly the sexiest way to do SQL to CSV is