Am 11.04.2016 um 06:26 schrieb Philip Rhoades: > People, > > I need to import a CSV dump from an Android SMS Sqlite DB - the problem > is, many of the SMSs have line breaks in the text body of the DB record > and this messes up the import into Calc. There does not seem to be any > way of saying to Calc: "Count x fields for each record" instead of > recognising a record by a LF . . > > Can anyone think of a nice, easy fix for this problem? > > Thanks, > > Phil.
You should be able to connect a Base document to the SQLite DB. Then your spreadsheet can access the database directly. CSV is not a file format. It is mere convention. If you have multi-line filds, you've got to export with text delimiters (in most cases quotes). Everything between a pair of text delimiters can be treated as one text value. -- To unsubscribe 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
