Altova Mailing List Archives>Archive Index >microsoft.public.xsl Archive Home >Recent entries >Thread Prev - Insert a CRLF when transforming XML into text >Thread Next - Re: Insert a CRLF when transforming XML into text Re: Insert a CRLF when transforming XML into textTo: NULL Date: 1/4/2009 1:58:00 AM On Sat, 3 Jan 2009 16:40:00 -0800, Savvoulidis Iordanis <SavvoulidisIordanis@d...> wrote: >I want to create a CSV (text) file out of a XML file, so it can be bulk >copied into SQLServer. How can I insert a CRLF char when I'm done converting >every record into its corresponding CSV? You need to add the character entity corresponding to a newline / carriage return after each output group (inside your xsl:for-each) : <xsl:text> </xsl:text> Note the snippet you provided should probably have a line after xsl:stylesheet and before xsl:template reading <xsl:output method="text" .... /> HTH Cheers - Neil ------------------------------------------------ Digital Media MVP : 2004-2009 http://mvp.support.microsoft.com/mvpfaqs | ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
