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

Are you using linux?

On 4/11/2016 6:30 AM, Andreas Säger wrote:
> 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