field delimiters in bcp

• Arif Khan

  SSC Veteran

  Points: 291

  More actions

  June 6, 2004 at 4:30 pm

  #85817

  Hi,

  I'm trying to copy data from table to textfile using bcp

  bcp is inserting spaces as field delimiters, I don't need any delimiters , I'm looking for for fixed width columns data to be transferred.

  here is the command i'm using

  exec master..xp_cmdshell 'bcp db.dbo.table OUT  D:\ak  -S server -U id -

  P pwd -c -r\n -t'.

  data in cols

  col1 :abc

  col2:xyz

  File should contain: abcxyz

  Thanks

   

   

• wz700

  SSCertifiable

  Points: 7133

  More actions

  June 7, 2004 at 5:11 am

  #509193

  use queryout, and in the query select col1+col2 from table.