GoAnywhere Forum

Hi,

I am using GoAnyWhere to create a CSV file from a SQL table, The output file will be having an extra line at the end of the file

Suppose if I have 86 records in database, then after 86 lines a new line (87) is being created at the end of the file.

As per my requirement I need to remove the last extra line, Can you help me in resolving this issue?

Thanks,
Sai.

Hello Sai,

GoAnywhere will not add a blank line or empty record at the end of the file, so the blank/empty record is coming from somewhere. To find out, you can use a (temporary) print statement to write each record to the log or to a test file, then look there for the blanks.

Setting the project to a debug log level may also help.

If you would like to send us your project XML, then we might be able to be more specific. Also, include the debug job log. [email protected]