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