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

Another useful tool for this type of clean-up is SED.  It can take some
trial & error and web searching if you're not familiar with sed or awk ....
but it's good knowledge to have.

On Mon, Apr 11, 2016 at 2:02 PM, Paul D. Mirowsky <p_mirowsky@bentaxna.com>
wrote:

> 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

-- 
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