Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to sort output of "s3cmd ls"

Amazon "s3cmd ls" takes like this output:

2010-02-20 21:01 1458414588   s3://file1.tgz.00<br>
2010-02-20 21:10 1458414527   s3://file1.tgz.01<br>
2010-02-20 22:01 1458414588   s3://file2.tgz.00<br>
2010-02-20 23:10 1458414527   s3://file2.tgz.01<br>
2010-02-20 23:20 1458414588   s3://file2.tgz.02<br>
<br>

How to select all files of archive, ending at 00 ... XX, with the latest date of fileset ?

Date and time is not sorted.

Bash, regexp ?

Thanx!

like image 375
dba.in.ua Avatar asked Apr 20 '10 10:04

dba.in.ua


Video Answer


2 Answers

s3cmd ls s3://bucket/path/ | sort -k1,2

This will sort by date ascending.

like image 111
Erik Kristensen Avatar answered Oct 10 '22 15:10

Erik Kristensen


DATE=$(s3cmd ls | sort -n | tail -n 1 | awk '{print $1}')
s3cmd ls | grep $DATE 

sorting as a number schould put youngest dates last. Tail -n1 takes the last line, awk cuts the first word which is the date. Use that to get all entries of that date.

But maybe I didn't understand the question - so you have to rephrase it. You tell us 'date and time is not sorted' and provide an example where they are sorted - you ask for the latest date, but all entries have the same date.

like image 11
user unknown Avatar answered Oct 10 '22 16:10

user unknown