.CSV Files

R

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
 
R

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.
 
Top