Carriage Return CSV (Unix format)

• b_boy

  Newbie

  Points: 0

  More actions

  October 27, 2008 at 12:16 pm

  #192769

  Hello

  Does anyone know how i can export data from sql server 2005 and create a carriage return (unix format) csv file, which is generated from a query.

  While this is done it is to be sheduled using a job, and an incremental file name will be created any time a job is excuted.

  filenames will be xxx0001 (if executed today), xxx0002(if executed tomorrow), xxx0003 (if executed the day after)

  Also the files will be dumped at a shared gateway server

• Scalability Doug

  Newbie

  Points: 0

  More actions

  October 27, 2008 at 12:41 pm

  #890187

  b-boy, if your data source for the CSV file is a query you can try this...

  Select + char(13) + char(10). This will append CR/LF characters to the last column.

  DAB

• b_boy

  Newbie

  Points: 0

  More actions

  October 28, 2008 at 2:40 am

  #890445

  Hiya

  Will this be at the end of my query, begining or within?

  eg:

  select * from table where + char(13) + char(10).

• Scalability Doug

  Newbie

  Points: 0

  More actions

  October 28, 2008 at 8:11 am

  #890647

  No, it is part of the SELECT clause...

  select servername, driveLetter + char(10) + char(13)

  from freedrivespace

  If the last column is numeric or date, you will need to wrap a CONVERT statement like

  [Code]select servername, convert(varchar,freespaceMb )+ char(10) + char(13)

  from freedrivespace[/code]