Start a new topic

@export does not write last newline character

[This topic is migrated from our old forums. The original author name has been removed]

Hi, it seems to me that the last line of an export with @export does not write the line terminator (\n). Subsequently, BCP (Sybase) import fails, and does not import the last line. Although there are literally hundreds of options to @export, is there none to write an essential newline at the end of the export file? Regards, Freewater

[This reply is migrated from our old forums.]

Re: @export does not write last newline character
Hi, I assume you see this with the CSV export format, where I can reproduce it. We will look for a solution. I have a nagging feeling that this is intentional because having a linefeed as the last character causes problems somewhere else, but we may make it optional of course. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: @export does not write last newline character
Freewater, We will fix this in the next version. Thanks for reporting it. Best Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: @export does not write last newline character
Thanks for the helpful reply!
[This reply is migrated from our old forums.]

Re: @export does not write last newline character
Hi, This is now fixed in the just released 7.0.6 version. Regards Roger