Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.