Hi,

in wxcwl i can do alt+enter in a cel to get a soft retrun
WHat ASCII seq should I use if I want to create a textfile in Universe
to import in excel to achieve the same?

Thanks
Frans

Frans,

Take a look at this:
http://www.pcreview.co.uk/forums/thread-1667348.php


Hope this helps.
Dave Weaver, Weaver Consulting

Frans wrote:

I recall having that problem once, I wanted my exported columns to wrap
so they wouldn't be too wide. I parsed out a raw excel file and I
believe I found that they used a CHAR(254) as a line break within a
cell.

At this point my brain went dead trying to figure out how to export an
attribute mark without disturbing my Pick file structure.

I guess Microsoft figured no one uses those high characters for
anything important.

Cheers


Frans wrote:

Thanks for your input but unfortunately I still cannot get it to work
:-(

I now heard tht it might work by using the .csv layout instead of a
txt so I'll try some struff over the weekend


Have a great 4th of July

Frans


On 1 Jul 2005 10:32:34 -0700, douglas (AT) pickteam (DOT) com wrote:

Frans wrote:
My solution would be to use HTML format and include a <br> in the data
within the <td></td> pair. There was a recent thread in cdp on using
HTML with Excel, but you should start here...

<URL:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoffxml/html/ofxml2k.asp>

HTH,
Luke

What you are trying here is a csv file i presume - each row on the
file ends with a 0d 0a ( it may look like char 254 but that is just
within your pic/uv system) an alt enter in a cell is 0a - problem is
pick/uv etc will interpret this as a new line and hence as char 254
again.

To get round this you can use the osbwrite instead of the writeseq in
uv (not sure about pick) or what i have in my linux box is a tr command
to convert another character (choose one) to 0d.