Convert Excel to CSV

[Joel Hammer]

Would it not be simple using something like sed to remove
the quotes from the csv file?

Email me a sample csv file and I will fiddle. It sounds
easy.

Joel
joel at hammershome.com


On Wed, Apr 28, 2004 at 10:27:52PM -0700, Shawn Tayler wrote:
> On Wed, 28 Apr 2004 13:03:04 -0500 "R. Quenett"<qcal at quen.net> exclaimed:
> 
> > This won't help if the command line is a critical requirement but OOo 
> > has an export to cvs option. I don't know how well it works. I've had 
> > good luck importing and converting m$ files with OOo).  Excel might 
> > also.
> > 
> > R
> 
> I've been doing this as well.  The issue I've run into and would dearly
> love the (most likely simple and obvious) solution too is, When I export
> spreadsheets, xls, to cvs using OO, the numeric contents of the cells are
> placed with double quotes ".  I'd like to remove the quotes but lack the
> traing, and mostly the time to fiddle.  Is there some group of scripts,
> awk, su, regular expressions, or perl that do this sort of thing?
> 
> Shawn
> _______________________________________________
> Linux-users mailing list
> Linux-users at smtp.linux-sxs.org
> Unsubscribe/Suspend/Etc -> http://smtp.linux-sxs.org/mailman/listinfo/linux-users