Re: [xsl] For CSV output file - should end of record marker be line feed or a carriage return from xsl

Subject: Re: [xsl] For CSV output file - should end of record marker be line feed or a carriage return from xsl
From: "Richard Fozzard - NOAA Affiliate richard.fozzard@xxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 7 Nov 2014 23:09:58 -0000
Wolfgang Laun wolfgang.laun@xxxxxxxxx wrote on 11/07/2014 02:06 PM:
You'll stand a better chance of getting your line ends right by using
<xsl:text>
</xsl:text>
with the line end being represented by whatever it is on the system where
the text file containing these two lines resides.
Agreed! If your XSLT is running on the same OS where you plan to use the CSV.

(This would be CR+LF on
Windowses, LF on Unices and CR on Mac OSs.)
BTW, the CR was only used on Mac OS 9 and earlier:

http://en.wikipedia.org/wiki/Newline#Representations

Mac OS 10.* shifted to Unix (FreeBSD) back in about 2001.


XML/XSL (and HTML) were designed from the ground up to handle just about any kind of end-of-line you wanted to throw at them. But of course, the program using your CSV may not be so tolerant. It sounds like you're using Windows, and some of those older Windows programs may require the traditional CR+LF.


--Rich

Explicitly requesting CR or LF or CR+LF means that the result will not necessarily have the intended line structure on one system or the other, i.e., wherever you run the XSLT.

-W

On 7 November 2014 18:40, Catherine Wilbur cwilbur@xxxxxxxxxxx <
xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> wrote:

1) Currently I am using a line feed in my code at the end.  Should it be a
line feed or carriage return?  Reason I am asking is because when I open my
CSV file in NotePad or WordPad the data wraps.  But with Notes++ or Excel
the data does not wrap.  Currently using a line feed at end of my data.
Assuming it should be a carriage return.  Guessing that the data is
wrapping when I open the CSV file because it does not recognize the
carriage return or line feed but Notes++ does recognize these characters.


http://stackoverflow.com/questions/7965642/explicitly-specify-linefeed-character-and-not-carriage-return


Should I be using a line feed in my code.  (this is what I am using now)
          <xsl:text>&#xA;</xsl:text>

Or should I be using a carriage return in my code.
  <xsl:text>&#xD;</xsl:text>


_____________________________________________________________________ Catherine Wilbur | Senior Application Programmer | IT Services 401 Sunset Avenue, Windsor ON Canada N9B 3P4 (T) 519.253.3000 Ext. 2745 | (F) 519.973.7083 | (E) cwilbur@xxxxxxxxxxx www.uwindsor.ca/its XSL-List info and archive <http://www.mulberrytech.com/xsl/xsl-list> EasyUnsubscribe <-list/528976> (by email <>)

Current Thread