CODEWITHSUNDEEP
linuxbashsortingconsole
mecio
mecio

Reputation: 263

Bash sort by regexp

I have something about 100 files with the following syntax

ahfsdjfhdfhj_EPI_34_fdsafasdf
asdfasdf_EPI_2_fdsf
hfdjh_EPI_8_dhfffffffffff
ffffffffffasdfsdf_EPI_1_fyyy44

...

There is always EPI_NUMBER. How can I sort it by this number?

Upvotes: 12

Views: 11768

Answers (4)

potong
potong

Reputation: 58381

This might work for you:

 ls | sed 's/.*EPI_\([0-9]*\)/\1 &/' | sort -n | sed 's/\S* //'

Upvotes: 2

holygeek
holygeek

Reputation: 16185

 sed -e 's/EPI_/EPI /' file1 file2 ...|sort -n -k 2 -t ' '

Pipe that to sed -e 's/ /_/' to get back the original form.

Upvotes: 3

anubhava
anubhava

Reputation: 785058

From your example it appears that delimiter is _ and text EPI_nnn comes at the same position after delimiter _. If that is always the case then you can use following command to sort the file:

sort -n -t "_" -k 3 file.txt

UPDATE:

If position of EPI_ text is not fixed then use following shell command:

sed 's/^\(.*EPI_\)\(.*\)$/\2##\1/' file.txt | sort -n -t "_" -k1 | sed 's/^\(.*\)##\(.*\)$/\2\1/'

Upvotes: 13

codaddict
codaddict

Reputation: 454970

If Perl is okay you can:

print sort foo <>;    
sub foo {
        ($x = $a) =~s/.*EPI_(\d+).*/$1/;
        ($y = $b) =~s/.*EPI_(\d+).*/$1/;
        return $x <=> $y;
}

and use it as:

perl prg.pl inputfile

See it

Upvotes: 4

Related Questions