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_mirow...@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+unsubscr...@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+unsubscr...@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