My xml export from Filemaker is to feed an InDesign template. I don't want avoid carriage returns in the InDesign doc. After some research I found a solution by substituting
Substitute ( textfield ; "¶" ; "
" )
(InDesign will give lovely 'soft returns' in return.) When I export the records to plain text, is preserved, though to xml it becomes


My conclusion that is an encoding issue. Is it? I tried different encodings without result. What is the solution? How can I force plain text into the xml file? thank you n
ADDED: The header of the xslt template:
<?xml version='1.0' encoding='utf-8'?>
<xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform' xmlns:fm="http://www.filemaker.com/fmpdsoresult" exclude-result-prefixes="fm">
<xsl:output version='1.0' encoding='utf-8' indent='yes' method='xml' />
<xsl:template match="/">
My conclusion that is an encoding issue. Is it?
No, it is not.
The problem is that you are trying to fool Filemaker's XML export logic and it won't let you. If you want the field to contain a character, you must use the character itself in the calculation, not its hexadecimal code (which is meaningless in Filemaker). That would mean:
Substitute ( textfield ; ¶ ; Char ( 8232 ) )
The other option is to do this in the XSLT stylesheet by:
<xsl:value-of select="translate(., '
', '
')"/>
This has the advantage of keeping all the export-related logic in the stylesheet and not burdening the solution with extra fields that serve no internal purpose.