Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

Re: Command to change file format to pipe delimited and copy to S3 bucket

open s3://accesskey:securitykey@s3.amazonaws.com/bucket/
put C:\FTPShare\*
Guest

Re: Command to change file format to pipe delimited and copy to S3 bucket

Thanks, but can you please suggest how to move it to the S3 bucket bypassing the conversion part?
martin

Re: Command to change file format to pipe delimited and copy to S3 bucket

WinSCP is not file format conversion tool. You have to use other tool for that.
bkandala@...

Command to change file format to pipe delimited and copy to S3 bucket

Hi All
I have the following script that gets the data from FTP server and copy it to my local drive.
option batch on
option confirm off
open ftp://username:password@FTPSITE/
cd /webpricingFTP/BC
option transfer binary
 get -preservetime *.csv C:\FTPShare\

What I am looking for is to change the file to a pipe delimited and copy to AWS S3 bucket, can someone please advice.
Thanks