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

Advertisement

bkandala@...
Guest

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

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
35,731
Location:
Prague, Czechia

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.

Reply with quote

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?

Reply with quote

martin
Site Admin
martin avatar

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\*

Reply with quote

Advertisement

You can post new topics in this forum