Write a file without the last hard return/carriage return/line feed.
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?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.