Write a file without the last hard return/carriage return/line feed.
Posted on 2006-10-19
I am using Microsoft SQL 2000 to create a flat file and all but the last record must end with a hard return. I am using bcp to write the file but when I open the file with a text editor, there is an additional line at the end. I have tried using REPLACE on the last line, but that didn't work.
How can I write this file without that last hard return?