How to export to xsl properly with commas and carriage return?

Discussion created by pleiades on Jul 25, 2017
Latest reply on Jul 26, 2017 by beverly



The description exported contains commas and carriage returns


Whenever I try to export the records, I get a problems in the export


There will be rows that is blank ( I think from carriage returns)


and some additional columns from descriptions with commas


The xls I use is below.


Is it possible to include both commas and carraige return to the xls?


Thank you!


<?xml version='1.0' encoding='utf-8'?>
<xsl:stylesheet xmlns:fmp=""
exclude-result-prefixes="fmp" version="1.0"
<xsl:output method="text"/>
<xsl:template match="/">

<!-- Header line, inserted only once; if not desired, remove -->

<xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW">
<xsl:variable name="posRow" select="position()"/>
<xsl:variable name="lastRow" select="last()"/>
<xsl:for-each select="fmp:COL/fmp:DATA">
<xsl:value-of select="."/>
<xsl:when test="position()!=last()">
<xsl:when test="position()=last() and $posRow!=$lastRow">




Update1: I made a mistake, it should be xsl not xls

Update2: The FMP is v14 and on Windows 7