Getting "question mark in block" at EOL in CSV files transformed fromXML

[david.karr]

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?

 

[david.karr]

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.