Scripted upload adds empty lines to csv-file

Advertisement

bakker_be
Joined:
Posts:
2

Scripted upload adds empty lines to csv-file

Hi there, I'm trying to automate the upload of a csv file through FTP, but for some strange reason this command
c:\program files\winscp\winscp.com "/script=C:\Data\PLANNING\PLANNING_20141228.txt"
adds a blank line after each line in my csv.
Content of the script file:
open ftp://user:pwd@ftp
cd /data
put C:\Data\PLANNING\PLANNING_20141228.csv
close
exit

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
41,518
Location:
Prague, Czechia

Re: Scripted upload adds empty lines to csv-file

How do you display the file to see that the blank line was added?
I would assume the CSV file has Windows line endings. Viewer expects Unix line endings and interprets the Windows line ending as an additional new line.
Try to use text transfer mode.
https://winscp.net/eng/docs/transfer_mode

Reply with quote

bakker_be

Hi Martin,
I open the file with Notepad++ or Programmer's Notepad, both display additional lines which weren't visible in the original file. I'll look into text-transfer.

Reply with quote

Advertisement

You can post new topics in this forum