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 3651 Jun 10, 2002, 1:13 PM
Thread Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
charly 3578 Jun 10, 2002, 1:46 PM
Thread Re: [charly] dbman -> dbman sql (paragraph indenting)
Reena0330 3579 Jun 10, 2002, 1:57 PM
Thread Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
charly 3560 Jun 12, 2002, 9:05 AM
Thread Re: [charly] dbman -> dbman sql (paragraph indenting)
charly 3573 Jun 15, 2002, 1:44 PM
Post Re: [charly] dbman -> dbman sql (paragraph indenting)
Reena0330 3531 Jun 21, 2002, 4:01 PM
Thread Re: [charly] dbman -> dbman sql (paragraph indenting)
Reena0330 3517 Jun 27, 2002, 5:14 PM
Post Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
charly 3499 Jun 28, 2002, 2:26 AM
Post Re: [Reena0330] dbman -> dbman sql (paragraph indenting)
YoYoYoYo 3165 Feb 12, 2003, 7:10 AM