Re: [sqlite] replacing all newlines in a field

On 2/11/08, BareFeet <[EMAIL PROTECTED]> wrote: > Hi Puneet, > > > I have a db in which the data in some fields in some tables has > > newlines (line breaks). All is fine until I want to export this into > > a CSV or tab-delimited format in which case the line breaks mess up > > the > > row-by-row

Re: [sqlite] replacing all newlines in a field

Hi Puneet, > I have a db in which the data in some fields in some tables has > newlines (line breaks). All is fine until I want to export this into > a CSV or tab-delimited format in which case the line breaks mess up > the > row-by-row records. How does it mess it up? CSV facilitates

Re: [sqlite] replacing all newlines in a field

Hi Puneet, Question: Is there a way I can search and replace all the line breaks? x'hh' should work, where hh are hex digits. So if your file contained hex 0D type line breaks: UPDATE t SET essay_without_newlines = Replace(essay, x'0D', '~'); This email and any attachments have been

[sqlite] replacing all newlines in a field

I have a db in which the data in some fields in some tables has newlines (line breaks). All is fine until I want to export this into a CSV or tab-delimited format in which case the line breaks mess up the row-by-row records. I am thinking, maybe I should not allow storing line breaks in the