Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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


  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.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.