Export to text file with quotes and pipes

• M-Hol

  SSC Eights!

  Points: 923

  More actions

  May 2, 2014 at 10:19 am

  #307443

  i have this script

  'Exec Master..xp_Cmdshell ''bcp "Select column1, column2, column3 from table1" queryout "Z:\Temp\text.txt" -t"|" -c -T'''

  and i have this file with the script

  data1|data2|data3

  data4|data5|data6

  data7|data8|data9

  But i need the file in this format

  "data1"|"data2"|"data3"

  "data4"|"data5"|"data6"

  "data7"|"data8"|"data9"

  how can i do it ?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  May 2, 2014 at 11:04 am

  #1710416

  A 10 seconds google search came up with this: http://stackoverflow.com/questions/2061113/sql-server-bcp-how-to-put-quotes-around-all-fields

  -- Gianluca Sartori