Unix sorting multiple conditions

Question

I have a file in which there are numbers like

6.3.0.00.220
6.3.0.00.220C
6.3.0.00.220EH
6.3.0.00.221
6.3.0.00.221C
6.3.0.00.221EH

and so on

I want them to be groped/sorted as

6.3.0.00.220EH
6.3.0.00.221EH
6.3.0.00.220C
6.3.0.00.221C
6.3.0.00.220
6.3.0.00.221

Basically EH ones together in ascending then C together in ascending and then the rest in ascending.

I am trying sort -k 1.10,1.14 -nr | sort -k 1.13 -r but not getting the exact output.

Max Value · Accepted Answer · 2016-05-04 09:18:52Z

3

Will this work for you sort -r -t. -k5.4 -s somefile.txt

edited May 4, 2016 at 9:18

answered May 4, 2016 at 7:22

Max Value

1738 bronze badges

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

1 Comment

jijinp Over a year ago

Avoid Useless use of cat

score 1 · Accepted Answer · 2016-05-04 07:04:19Z

1

Test file:

$ cat test.txt 
6.3.0.00.220
6.3.0.00.220C
6.3.0.00.220EH
6.3.0.00.221
6.3.0.00.221C
6.3.0.00.221EH

Running a command:

$ cat <(grep -E -e "EH$" test.txt | sort) \
      <(grep -E -e "C$" test.txt | sort) \
      <(grep -E -v "(EH)|(C)$" test.txt | sort)
6.3.0.00.220EH
6.3.0.00.221EH
6.3.0.00.220C
6.3.0.00.221C
6.3.0.00.220
6.3.0.00.221

edited May 4, 2016 at 7:04

answered May 4, 2016 at 6:38

user184968

4 Comments

user184968 Over a year ago

Look, I have updated my answer to show that is works.

Mohit Arora Over a year ago

I guess I am doing something wrong not working for me can we do it through sort command,

user184968 Over a year ago

I have found an error. I forgot to sort each grep command's output. However, it migth be useful if you mention what doesn't work.

Mohit Arora Over a year ago

It removes the EH numbers and gives me the leftovers in the file.

Collectives™ on Stack Overflow

Unix sorting multiple conditions

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related