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 wrote: > This is more specific. > > I

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

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