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: [email protected] 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
