BCP text file is adding an extra line at the end of the file

• Jeff Moden

  SSC Guru

  Points: 1004600

  More actions

  March 14, 2016 at 8:05 pm

  #1865108

  Lowell (3/14/2016)

  ---

  I'm going to agree with Orlando's lat post that this is the expected behavior.

  {somedata} + {row delimiter}, which in this case is CrLf, puts the cursor on the next line.

  I'll 3rd that. It's not an extra line... it's that every line has and is supposed to have a line terminator as Orlando and Lowell have both stated.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)