View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
david.karr david.karr is offline
external usenet poster
 
Posts: 13
Default Getting "question mark in block" at EOL in CSV files transformedfrom XML

On Mar 2, 10:54*am, "david.karr" wrote:
I'm writing an XSLT stylesheet to generate a CSV file from an XML
file. *Some of the fields have embedded newlines. When I open the
result in Excel, each value that has embedded newlines has a "question
mark in block" character at the end of the embedded line. *I need to
figure out how to prevent this in the stylesheet, but I first have to
figure out how to prevent it in the CSV. *What do I have to do here?


I still could use some help with this. In the cell data in the CSV
file, I just have "\r\n" (carriage return and line feed) at the end of
each line, but when I view this in Excel, it correctly renders a
newline, but also puts the odd "question mark in block" character at
the end of the embedded line in the cell.