Carriage return?

  • Thread starter Thread starter Gordon Welsh
  • Start date Start date
G

Gordon Welsh

Hi, not sure if this is the right place for this - if not,
please point me in the right direction, but if so:

We are using Oracle CRM and have recently got an add-pack
which allows us to place data from a database view into a
Word document template.

It's all working fine except that one of the items we are
bringing back is supposed to split over several lines. The
problem is that when this item is displayed in Word, where
we would expect a carriage return, a small white box is
displayed.

We've got round this for now by amending the pl/sql used
to create the view so that it replaces the carriage
return, chr(10), with a full-stop and a space, '. ' but,
although this is neater than the square, we really need to
split the text up so that it appears in the document as it
does in CRM.

So my question is, does anyone know if I can replace '. '
with something that Word will interpret as a carriage
return?

Thanks in advance.

Gordon
 
Try using both chr(13) & chr(10) together. Which should be interpreted as
Carriage Return and Line Feed.

--
Dawn Crosier
"Education Lasts a Lifetime"

This message was sent to a newsgroup. Please post back to the newsgroup so
all may follow the thread.
 
chr(13) on it's own did the trick, thanks

Gordn

----- Dawn Crosier wrote: ----

Try using both chr(13) & chr(10) together. Which should be interpreted a
Carriage Return and Line Feed

-
Dawn Crosie
"Education Lasts a Lifetime

This message was sent to a newsgroup. Please post back to the newsgroup s
all may follow the thread
 
Back
Top