[libreoffice-users] Re: Importing CSV file into Calc with records determined by the number of field separators instead of Line Feeds

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: users+unsubscribe@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