Newlines in csv files
"Marvin P. Winterbottom"
wrote in message ...
You have to somehow get rid of the carriage returns in the textbox, excel
is
seeing them as end-of-record even if they are in the quotes.
In that text field, can you replace chr(13) with a slash "/" or something?
I realized that. I just don't know what to change it to. I don't want to
use something like a slash as that may show up in the text as well.
I was hoping there was a way to tell excel to ignore newlines when inside
the Quotes. If it doesn't what good are the Quotes?
Thanks,
Tom
"tshad" wrote:
I have a problem with a .csv file I am trying to read into an excel
sheet.
I have all of my fields surrounded by quotes to prevent commas inside a
text
field from being mistaken for a field separator. The problem is that
some
of my fields have newlines in them as they are taken from a multiline
textbox on my web page and put into my sql table. I then read the sql
table
and write out the table in .csv format. But I think the newlines are
being
mistaken for line separators - even if within quotes.
If I have a text with 3 new lines, they will end up on 4 lines of my
Excel
sheet.
Why is that? Is there a way around this problem?
Thanks,
Tom
|