Export field as text XML/XSL makes double (CR) (LF) problem

[enghult]

Hi!

I´ve read several posts on this forum and tried different xsl examples, but I still have the same problem. I get double

in my exported textfile.

To explain the whole problem:

I want to create a file from a textfield in FM. The textfile acts as an command parameter file for a 16 bit DOS-program.

I I create the textfile in Notepad and run the DOS-program all works fine, but if I create the textfile from a exported field in FM it won´t work.

The export field does not work.

Ive tried the export as XML with an XSL file that looks like this:

<?xml version="1.0" encoding="utf-8"?>



xmlns:fm="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fm" >

	

	

		

	

I changed this line:

to iso-8859-1 from utf-8 from the example FM_Data1.xsl



A simple test with this content in the output field:

"a"  & ¶ & 

"b" & ¶ & 

"å"

"Export record[No dialog;"abå_fmp_xml.txt";"FMPXMLRESULT";"FM_Data1.xsl";Unicode (UTF-8)"

...produces this textfile:

a

b

å

and viewed as ASCII: (& removed)

#97;#13;#10;#13;#10;#98;#13;#10;#13;#10;#229;

I think the textfile would work with only one pair of "#13;#10" but I don´t know how to fix this.

Edited February 28, 2008 by Guest