Convert Excel to CSV

R. Quenett qcal
Mon May 17 12:01:45 PDT 2004


mutilated misquotes 
from Shawn Tayler's 28 Apr 2004 classic prose
may follow:

" 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?

I don't usually export to csv but I just tried a .sxc, don't have a 
.xls handy, and got no quotes around the numbers.  OOo 1.1.0 on 
<shame>windows</>.  Maybe convert to .sxc first?

R
-- 
http://www.quen.net

To call a politician a liar is an unearned and unjustified compliment.



More information about the Linux-users mailing list