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