If you want to insert the line break in excel's 'native
language'/character set, shouldn't you be creating the file in excel's native
format, rather than as a tab-delimited file? I'm afraid I don't know the
solution either, but that may at least explain the results you're
getting.
Richard B. Lewis
Sr. Software Engineer
Dynix
p 801-223-5392
f 801-223-5202
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Burwell, Edward
Sent: Tuesday, January 27, 2004 3:51 PM
To: '[EMAIL PROTECTED]'
Subject: UD Coding a 'Hard Carriage Return" for an Excel file
Hello,
I am creating a tab-delimted file with and xls extension that excel is very happy to open. I would like to create a cell that has line-breaks or Hard-Carriage-Returns in them. You can accomplish this manually by pressing
ALT+ENTER while entering data into a cell. I belive the character is
ALT+the
same as what you get in MSWORD when you hold the ALT key and enter 0010.
Here is a snippet of the code that I am using:
284: TAB=CHAR(9) ; CR=CHAR(13) ; LF=CHAR(10) ; CRLF=CR:LF
285: *---- ----*
286: HDR=SOURCE:TAB
287: HDR:=\=\:QUOTE(INVOICE):TAB ; * to force excel to see this as
text
288: HDR:=CUST:TAB
289: *---- ADDRESS ----*
290: IF FULL.ADDRESS THEN
290: *---- set Line Break character ----*
291: * LB=CHAR(1034) ; * CHAR(10) + CHAR(1024) - ALT KEY
292: * LB=CR ; * CHAR(13)
293: * LB=CRLF ; * CHAR(13) : CHAR(10)
294: LB=LF ; * CHAR(10)
295: ADDR=NAME:LB
296: IF LEN(AD1) THEN ADDR:=AD1:LB
297: IF LEN(AD2) THEN ADDR:=AD2:LB
298: IF LEN(ATTN) THEN ADDR:=ATTN:LB
299: ADDR:=CITY:", ":ST:" ":ZIP
300: HDR:=QUOTE(ADDR):TAB
301: END ELSE
302: HDR:=NAME:TAB
303: END
When I manually enter data into a cell and press ALT+ENTER for a hard-carriage-return, then copy and paste that cell into notepad, I see a square non-printable character where the carriage-returns were. When I look at that square in a hex viewer, its 0A or ASCII 10, char(10), the line feed character.
When I run the above code then open the file in excel and look at the cell, it seems to work, however, now there is a visible square right where I put the char(10)'s! I get the same result when I use CRLF as well. When I use CR only, it doesn't wrap at all.
Any help would be greatly appreciated.
Also - I am only receiving the Digest, but I want to receive all postings (and the Digest). I went to the site and my settings look ok. My IE cookie setting is medium, but that's what it's always been. If someone could tell me how to get all mailings that would be appreciated also!
Thanks in advance.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
_______________________________________________
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
_______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
