.CSV Files

[Roman]

My csv file is delimited by commas and text is delimited by ". My file
considers carriage returns and next line characters enclosed in " as
text. I am facing a problem when trying to open this file in excel.
The excel doesn't care that next line character enclosed by " and
thinks it is the end of a record. Is there a way to excel that
anything inside " should be treated as text?

Thanks in advance

 

[Kurt]

After playing around with this, it apears Excel uses a linefeed (0x0A)
within quotes to denote a newline within text in the same cell. So a csv
file like:

"This is <0x0A> Cell one", "This is <0x0A> Cell two"

loads into Excel as


A | B
------------------------
| This is | This is |
1| Cell one | Cell two |
| | |
-------------------------

You may have to write a bit of code that will strip the carriage returns
that occur between quotes.

....kurt

 

[Roman]

Thanks for your help. Actually, it should be pretty simple with python
or save the file in a pc format which would strip the carriage returns.