Re: [libreoffice-users] Calc: Text Columns Not Quoted When Saving .csv

On Sat, 22 Dec 2012, Brian Barker wrote:

> Could you convert your empty cells to blank, output as CSV, read this into
> your other program, and then - only if necessary - edit the blanks back to
> null?

Brian,

  One does not 'read' the file into a SQL database such as postgres. When a
column attribute type is text SQL wants to see it quoted; when it's numeric
(INTEGER, REAL) it cannot be quoted. For the record, DATE attributes, even
in ISO format (YYYY-mm-dd) must be quoted for SQL to properly interpret it.

> Can your other programs cope only with CSV files?  Not spreadsheet
> document files?

  Nope. SQL wants certain formats, and R might be able to read spreadsheets
but I work with plain ASCII text files for almost everything.

Rich


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted