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

This is more specific.

I assume you have text delimited by double quotes.

http://stackoverflow.com/questions/26406281/replace-new-line-character-between-double-quotes-with-space

On 4/11/2016 11:35 AM, Paul D. Mirowsky wrote:
> 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