How can I remove the 1st line of a CSV file which is in AWS S3 through

user_2848700 0
Viewed 208

I am trying to remove the 1st line of a CSV file which is in S3 bucket. I am using the below, but I am getting "sed: no input files" and is creating empty file in the test directory.

aws s3 cp  s3://my-bucket/rough/test.csv  -| sed -i '1d' | aws s3 cp -  s3://my-bucket/test/final.csv
amazon-ec2 command-line-interface amazon-s3
1 Answers

If you run the steps one-by-one, you will see an error:

sed: -I or -i may not be used with stdin

So, use this:

aws s3 cp s3://my-bucket/rough/test.csv - \
    | sed '1d' \
    | aws s3 cp - s3://my-bucket/test/final.csv
user_2714150
Related