Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    5

    Unanswered: bcp queryout strange behaviour

    I use bcp fairly often in SQLServer2000 but have never run across this before. In a 512 SQLCHAR column containing notes, when two spaces are encountered (i.e. ' '), bcp is replacing ' ' with '\r\n'.

    I figured it was a problem with my format file, but I have not found enough specific info on the MSDN site to resolve this.

    This is my bcp command:

    bcp "SELECT DivCode,CommCode,ContactID,substring(Notes, 0, 512) from frep.dbo.BeBackExtract" queryout "D:\BeBackDetail.dat" -f "D:\BeBackDetail.fmt" -e "D:\BeBackDetailErrors.dat" -U user -P pass -S server

    And format file:

    8.0
    4
    1 SQLCHAR 0 2 "" 1 DIVCODE ""
    2 SQLCHAR 0 3 "" 2 COMMCODE ""
    3 SQLCHAR 0 10 "" 3 CONTACTID ""
    4 SQLCHAR 0 512 "\r\n" 4 NOTES ""

    Has anyone seen this?

    Incidentally I also tried using the REPLACE function which seems to work great until trying to replace 2 spaces with 1 space, in which case it doesn't do anything.

    Thanks for any ideas -

  2. #2
    Join Date
    Aug 2007
    Posts
    5
    BTW the site trimmed my ' ' strings - those are supposed to appear as two spaces. So i.e. "...bcp is replacing ' ' with '\r\n'." should contain 2 spaces within the first string.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •