Hmm, I could be wrong, but:

If a newline is \n (or it might be \r\n) and the CSV format typically uses \
as an escape character, you might try putting:

\\n in place of any \n you want to keep in a cell. So:

--
Row 1:\\nColumn 1,Row 1:\\nColumn 2\r\n
Row 2:\\nColumn 1,Row 2:\\nColumn 2\r\n
--

How does that work for you?


Henning Sittler
www.inscriber.com


-----Original Message-----
From: Luke Jiang [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 11:28 AM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: Word wrap in MS CSV File.


G'day

Just wondering how can I put multiple lines in a cell in a Microsoft CSV
file.

The CSV uses , and <newLine> as delimiters.. a <newline> in a cell is
intrepreted as start of next row

Regards

Luke
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body

Reply via email to