Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [Reena0330] dbman -> dbman sql (paragraph indenting)

Quote Reply
Re: [Reena0330] dbman -> dbman sql (paragraph indenting) In reply to
Hi Reena - and I hope Alex sees this too!

If I do a cut and paste online there is no problem, my text gets formatted properly. But with imports that's not the case.

Alex says:
---
Hmm, the import should have handled this. The `` are from the flatfile
version. A quick fix would be to go to SQL Monitor and type:

UPDATE table SET col = REPLACE(col, "``", "\n");

where table is the name of the SQL table and col is the column name that
has the `` chars in it.
---
I confirm that the import does not handle this. Testing Alex's 'Quickfix', there is no change and the linefeeds are still not converted. To be precise, in my imported file what you Reena see as apostrophes, in mine is present as hex 0B data and this is not converted into <CR>.

I hope that GT can make progress on this issue which has been dogging me for over a month!!
Hopeful
Charly
Subject Author Views Date
Thread dbman -> dbman sql (paragraph indenting) Reena0330 5073 Jun 10, 2002, 1:13 PM
Thread Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
charly 4981 Jun 10, 2002, 1:46 PM
Thread Re: [charly] dbman -> dbman sql (paragraph indenting)
Reena0330 4981 Jun 10, 2002, 1:57 PM
Thread Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
charly 4963 Jun 12, 2002, 9:05 AM
Thread Re: [charly] dbman -> dbman sql (paragraph indenting)
charly 4977 Jun 15, 2002, 1:44 PM
Post Re: [charly] dbman -> dbman sql (paragraph indenting)
Reena0330 4934 Jun 21, 2002, 4:01 PM
Thread Re: [charly] dbman -> dbman sql (paragraph indenting)
Reena0330 4922 Jun 27, 2002, 5:14 PM
Post Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
charly 4898 Jun 28, 2002, 2:26 AM
Post Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
YoYoYoYo 4565 Feb 12, 2003, 7:10 AM