multiple field and numeric sort

Question

List of files:

sysbench-size-256M-mode-rndrd-threads-1
sysbench-size-256M-mode-rndrd-threads-16
sysbench-size-256M-mode-rndrd-threads-4
sysbench-size-256M-mode-rndrd-threads-8
sysbench-size-256M-mode-rndrw-threads-1
sysbench-size-256M-mode-rndrw-threads-16
sysbench-size-256M-mode-rndrw-threads-4
sysbench-size-256M-mode-rndrw-threads-8
sysbench-size-256M-mode-rndwr-threads-1
sysbench-size-256M-mode-rndwr-threads-16
sysbench-size-256M-mode-rndwr-threads-4
sysbench-size-256M-mode-rndwr-threads-8
sysbench-size-256M-mode-seqrd-threads-1
sysbench-size-256M-mode-seqrd-threads-16
sysbench-size-256M-mode-seqrd-threads-4
sysbench-size-256M-mode-seqrd-threads-8
sysbench-size-256M-mode-seqwr-threads-1
sysbench-size-256M-mode-seqwr-threads-16
sysbench-size-256M-mode-seqwr-threads-4
sysbench-size-256M-mode-seqwr-threads-8

I would like to sort them by mode (rndrd, rndwr etc.) and then number:

sysbench-size-256M-mode-rndrd-threads-1
sysbench-size-256M-mode-rndrd-threads-4
sysbench-size-256M-mode-rndrd-threads-8
sysbench-size-256M-mode-rndrd-threads-16
sysbench-size-256M-mode-rndrw-threads-1
sysbench-size-256M-mode-rndrw-threads-4
sysbench-size-256M-mode-rndrw-threads-8
sysbench-size-256M-mode-rndrw-threads-16
....

I've tried the following loop but it's sorting by number but I need sequence like 1,4,8,16:

$ for f in $(ls -1A); do echo $f; done | sort -t '-' -k 7n

EDIT:

Please note that numeric sort (-n) sort it by number (1,1,1,1,4,4,4,4...) but I need sequence like 1,4,8,16,1,4,8,16...

choroba · Accepted Answer · 2013-04-30 11:54:19Z

5

Sort by more columns:

sort -t- -k5,5 -k7n

Primary sort is by 5th column (and not the rest, that's why 5,5), secondary sorting by number in the 7th column.

edited Apr 30, 2013 at 11:54

answered Apr 30, 2013 at 11:30

choroba

245k27 gold badges221 silver badges304 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

msw Over a year ago

This command is accepted but seems to silently ignore the n (using GNU sort 8.20)

msw · Accepted Answer · 2013-04-30 11:50:44Z

4

The for loop is completely unnecessary as is the -1 argument to ls when piping its output. This yields

ls -A | sort -t- -k 5,5 -k 7,7n

where the first key begins and ends at column 5 and the second key begins and ends at column 7 and is numeric.

answered Apr 30, 2013 at 11:50

msw

43.7k9 gold badges92 silver badges117 bronze badges

Collectives™ on Stack Overflow

multiple field and numeric sort

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related