Need to remove the last extra line from CSV file

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
2 posts Page 1 of 1

sai krishna

Posts: 1
Joined: Fri Jan 22, 2016 1:44 pm

Post by sai krishna » Fri Jan 22, 2016 3:12 pm
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.

Support_Tim

Posts: 35
Joined: Mon Dec 01, 2014 10:35 am

Post by Support_Tim » Wed Jan 27, 2016 6:00 pm
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]
2 posts Page 1 of 1