XSL Linefeeds

May 15, 200817 yr

I have an XSL sheet for creating CSV data files.

It strips any extra return characters and commas from the data and creates the CSV without having quotes around all the data.

The trouble is I need to have carriage return+line feed as the EOL char. For some reason I am getting two carriage returns + line feed. Please see attached CSL file. Any help greatly appreciated!

data.xsl.zip

1 month later...

June 30, 200817 yr





Are you really trying to strip out (in this order):

"," CR LF



? If so, you might not be actually stripping them out, and therefore are keeping them AND adding the $crlf at the end.



Maybe you need to do this:

July 2, 200817 yr

Author

Thanks for the reply Beverly. However the Translate function is working fine. The problem is not in the charaters I am taking out of the data, it is in the CRLF I am trying to put in. The $crlf variable does not output a simple crlf sequence.

cheers!

July 2, 200817 yr

FWIW, I used your file to perform a test export, and the lines end exactly with CRLF - no duplication.

---

Oh, - here's the file, in case it helps.

result.txt.zip

Edited July 2, 200817 yr by Guest

July 2, 200817 yr

Author

Hi - sorry forgot to point out that this is to run on a windows platform. I have just tried it on a MAC and it works fine. On a PC it does not.

3 weeks later...

July 18, 200817 yr

OK, I've run into this a few times in the last 2 weeks. IF your xsl:output _method_ is "text", then you must, let me repeat: MUST, optimize your XSLT. What that means is remove any and ALL whitespace from between and around tags and text, unless the text is intended to be included.

What you are seeing (on windows) is the additional whitespace (returns) that are in the XSLT. It shouldn't be that way, they should be [color:red]IGNORED, but there appears to be a bugglet there (windows only, as mac does not require the optimization).

Try it and let us know if that's the solution.