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

bkandala@... Guest

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

2021-05-28 21:01

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

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,478
Location:: Prague, Czechia

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

2021-06-01

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

Reply with quote

Guest

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

2021-06-01 13:46

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

Reply with quote

martin◆ Site Admin

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

2021-06-04

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

Reply with quote

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

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

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

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

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

Documentation

Support

Associations

Follow Us