[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 679
  • Last Modified:

What is the syntax for spaces in FTP return path?

Hello Experts,
What syntax do I need for a path in FTP that contains spaces?
Thank you
0
davidam
Asked:
davidam
  • 3
  • 2
2 Solutions
 
AlexPaceCommented:
The FTP standard is silent on the issue so different FTP servers use different path separator characters.  This can be annoying if you want to write a script that works on multiple servers.
0
 
davidamAuthor Commented:
For me it is a client issue since it is our server.   I cannot even make the vba editor accept most of the things that I attempt.  It rejects double quotes, puts in semicolons and does all sorts of strange things. I suppose also, that if I make something work on one client, it will not work on another.  It sounds to me like I need to be going in the direction of temp directories on client machines.
0
 
AlexPaceCommented:
I made a new directory named "sub folder" on my local FTP site and then tested it using my local FTP client.  It worked for me and the protocol trace log shows that the command sent from client to server contained no quotes or anything, just plain CWD sub folder  (CWD = change working directory)
Tue May 03 11:49:55  => ->- CWD sub folder
Tue May 03 11:49:55  => Status: Executing command on the server
Tue May 03 11:49:55  => Status: Connected to server - idle
Tue May 03 11:49:55  => -<- 250 CWD command successful
Tue May 03 11:49:55  => RawSend returning 250
Tue May 03 11:49:55  => ->- PWD
Tue May 03 11:49:55  => Status: Executing command on the server
Tue May 03 11:49:55  => Status: Connected to server - idle
Tue May 03 11:49:55  => -<- 257 "/sub folder/" is current directory

Open in new window

0
 
davidamAuthor Commented:
I have been running the FTP from a batch file.  This works fine as long as there are no spaces in either the send and get lines or in the file folder location...vba can have problems naming the batch file properly if there are spaces. So my solution is to create a temp folder on the C drive and copy a temporary file with the ftp instructions to this directory and then run the application from inside the temporary file/folder. Probllm solved if not very elegant.
0
 
davidamAuthor Commented:
The truth about this issue is as AlexPace says...ftp is silent about it and you need to create your own solutions...mine has worked for me.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now