@export (problems with End of File)

Always when i am using @export, i have an extra empty line at the end of the file that i am generating, and this line generates me an error when i use this file to import its content. How can i eliminate that line when i am generating this file?(i double check query and results are not giving me empty lines).

Roger This is the script i am trying to execute:(Thanks a lot for your help) @export on; @export set filename="c:\Test\export\SalesOrder\${table}.csv" format="csv" CsvIncludeColumnHeader="false" ; select field1, field2, field3,field4,field5,field6 from tlib.as400table where field1 =(month(current timestamp)-1) and field2=day(current timestamp)-1 and field3=year(current timestamp) and field8='D' order by field4 desc; @spool log dbvis.log; -- Saves the Log to a file named dbvis.log @exit;

Roger I did execute only SELECT statement and i did not get that line , that is what i did when i first saw empty line for first time into my file.

Roger I did that , and i could see that exporting manually , csv appears without that empty line(i followed all steps you said, now i really dont know what is generating that empty line). Thanks a lot for your time.

Hello Roger Any idea why i had that blank line ? i would appreciate so much your help. Best Regards

Roger I installed last version (6.0.13) and it did not work, i was checking and it seems i dont have a blank line, what is getting is only a change of line after last row, no idea how can i avoid that change of line? Regards

Thanks a lot for your support!!!, Amazing!!

Roger I would appreciate that you let me know when fix is ready, is it ready yet? in which version fix is gonna be ready? Thanks a lot for your support!!!

Roger Thanks a lot , Seriously you save the job of a lot of guys (5 at least)..jeje Best Regards