Hi all, I'm importing and exporting a CSV file through Calc. The data is generated by a script, and the result must be readable by other bash scripts.
Every field is quoted in double quotes, and I'm using commas as the delimiter. However, OO.o Calc mangles dates. The dates are written in ISO short format (YYYY-MM-DD), but Calc automagically converts these to dates. I then select the column and format it as "text", and I get fields like "38846" for "2006-05-09". I want these to remain in the human readable format they were written in. Additionally, when exporting these fields, it strips out the quote marks. This makes it difficult for the other scripts to parse. Is there a way to control Calc's automagic sensing-and-mangling of formats? How can I protect these dates (and other non-text values)? As a workaround, I'm making all my apparently-numeric fields into text fields by inserting some non-numeric character in there: an underscore to prefix the ISO date, and a "v" to prefix a version number. Thanks! Regards, Richard Smit --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
