Jonathan Kaye wrote:
Jerry Feldman wrote:
While generating a CSV, Calc generates some quotes where (I believe)
Excel does not.
A short example is this is part of the input file, in this case a csv:
Input CSV:
Schedule Curve,ID,Name,
Result CSV:
"Schedule Curve","ID","Name",
The problem is that the tool that reads this is picky and does not like
the quotes. But, the resultant file does require some editing because
neither Excel nor Calc generates the dates in the needed format:
yyyy/mm/dd. Swedish comes close with yyyy-mm-dd, but again the tool
likes the forward slashes.
Hi Jerry,
It's easy to remove the quotes as text delimiters. Open the offending csv
file and you'll see the Text Import" window. To the right of Text delimiter
you'll see a drop down menu with " or ' (default is ") click in that field
and erase the quotes. Same thing when you are saving the files. When you
see the Text Import window, make sure the Text delimiter field is empty.
HTH,
Jonathan
I've done this and it does work. But I have another problem along a
similar line. I have a spreadsheet template that I fill and then
export/save to csv format. The template has 5 columns that have formulas
in them. The formulas check for the presence of data in column A and if
it exists, make a calculation and fill the cell. If it doesn't exist,
the cell is empty (except for the formula). Sometimes I may have 2 or 3
rows of data, other times 500 rows or more. When I export to csv, the
default behavior is to place double quotes in all of the empty cells
where calculations were performed. I can suppress the double quotes, but
the cells still contain the formula and every possible row is exported
whether it's has data or not. I end up with csv file that has 64,000
rows, mostly blank. Is there a way to not export/save empty rows that
only contain formulas?
Thanks,
Rick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
