Carriage Returns in XML!!!

[Brett W]

Hi Everyone,

I have a quick question about how to preserve carriage returns in FileMaker's XML Export. I have a XSLT sheet that converts the XML to a XLS file so I can natively open the file in Excel. The problem is that the carriage returns are not being well formed in the XML, so they are just being ignored. I have tries using calcs to export " " in the place of the CR, but that doesn't work either because the XSLT just reads it as data:

It just reads it as DATA!

Any help would be appreciated.

[comment]

I don't have Excel, but I believe you need a LINE FEED (LF) character (#10 or #x000A).