Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Extra CR LF

Author  Topic 

satheesh
Posting Yak Master

152 Posts

Posted - 2014-05-23 : 06:37:35
Hi All,

I have created a store procedure and scheduled a report via SSRS to save as .CSV file. I am getting files with out any issue. But the file contains an extra CRLF in the last row. I want to remove this CRLF (no data in last row, just CRLF is there when opening the file using notepad++). How to remove this CRLF. Where i need to amend this. Any help will be highly appreciated.

Thanks

Regards,
SG
   

- Advertisement -