Custom sort on a column

12-10-2014

Registered User

174, 45

Join Date: Oct 2014

Last Activity: 8 April 2019, 3:29 PM EDT

Posts: 174

Thanks Given: 78

Thanked 45 Times in 45 Posts

Custom sort on a column

Hello all,

How do I achieve this? I have A, B and A/B in different variables in a file in col2.
I want them to sort in such a way, that the variables appear together, and within a variable, the data is sorted in the order A,B and then A/B. If I sort on the second column, the order becomes A, A/B, B but I want A,B,A/B.

IN

Code:

Variable1 A/B 1
Variable2 A    2
Variable3 B    3
Varibale2 B    4
Variable2 A/B 5
Variable2 A/B 6
Varibale1 A/B 7
Variable1 B    8
Variable1 A    9
Variable3 A    10
Variable3 A/B 11

OUT

Code:

Variable1 A    9
Variable1 B    8
Variable1 A/B 1
Varibale1 A/B 7
Variable2 A    2
Varibale2 B    4
Variable2 A/B 5
Variable2 A/B 6
Variable3 A    10
Variable3 B    3
Variable3 A/B 11

senhia83

View Public Profile for senhia83

Find all posts by senhia83

12-10-2014

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

Try:

Code:

sort -k1,1 -k2.3,2.3 -k2.1,2.1 file

--
Note, there are letters reversed

Code:

..
Varibale2 B    4
Variable2 A/B 5
Variable2 A/B 6
Varibale1 A/B 7
..

in your sample input file

These 2 Users Gave Thanks to Scrutinizer For This Post:

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

12-14-2014

Registered User

174, 45

Join Date: Oct 2014

Last Activity: 8 April 2019, 3:29 PM EDT

Posts: 174

Thanks Given: 78

Thanked 45 Times in 45 Posts

This doesn't seem to work for a comma delimited file if I use sort -t, option. Any easy fix for this?

senhia83

View Public Profile for senhia83

Find all posts by senhia83

12-14-2014

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

It should, could you provide a sample input file?

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

12-14-2014

Registered User

174, 45

Join Date: Oct 2014

Last Activity: 8 April 2019, 3:29 PM EDT

Posts: 174

Thanks Given: 78

Thanked 45 Times in 45 Posts

Here is an example

Code:

 
 cat > tmp
XTurb7670,B,AA,Filo060E-02052
XTurb7670,A/B,AA,Filo067E-02068
XTurb7670,A/B,AA,Filo067E-02070
XTurb7670,A/B,AA,Filo067E-02071
XTurb7670,A/B,AA,Filo067E-02073
XTurb7670,A/B,AA,Filo067E-02075
XTurb7670,A/B,AA,Filo067E-02076
XTurb7670,A/B,AA,Filo067E-02083
XTurb7670,A/B,AA,Filo067E-02084
XTurb7670,A/B,AA,Filo067E-02086
XTurb7670,A,GG,Filo067E-02065
 $ sort -t, -k1,1 -k2.3,2.3 -k2.1,2.1 tmp
XTurb7670,B,AA,Filo060E-02052
XTurb7670,A/B,AA,Filo067E-02068
XTurb7670,A/B,AA,Filo067E-02070
XTurb7670,A/B,AA,Filo067E-02071
XTurb7670,A/B,AA,Filo067E-02073
XTurb7670,A/B,AA,Filo067E-02075
XTurb7670,A/B,AA,Filo067E-02076
XTurb7670,A/B,AA,Filo067E-02083
XTurb7670,A/B,AA,Filo067E-02084
XTurb7670,A/B,AA,Filo067E-02086
XTurb7670,A,GG,Filo067E-02065

senhia83

View Public Profile for senhia83

Find all posts by senhia83

12-14-2014

Registered User

15,129, 5,008

Join Date: Jul 2012

Last Activity: 4 May 2020, 4:31 PM EDT

Location: Aachen, Germany

Posts: 15,129

Thanks Given: 735

Thanked 5,008 Times in 4,483 Posts

Seems not to be due to the delimiter but due to an inappropriate key. -k2.3 points to nowhere for first and last line.

RudiC

View Public Profile for RudiC

Find all posts by RudiC

12-14-2014

Registered User

12,315, 4,560

Join Date: Jul 2012

Last Activity: 22 November 2019, 4:29 PM EST

Location: San Jose, CA, USA

Posts: 12,315

Thanks Given: 952

Thanked 4,560 Times in 3,818 Posts

This will do what I think you want for your sample input on some systems (including OS X):

Code:

sort -t, -k1,1 -k2.3,2 -k2.1,2.1 tmp

producing:

Code:

XTurb7670,A,GG,Filo067E-02065
XTurb7670,B,AA,Filo060E-02052
XTurb7670,A/B,AA,Filo067E-02068
XTurb7670,A/B,AA,Filo067E-02070
XTurb7670,A/B,AA,Filo067E-02071
XTurb7670,A/B,AA,Filo067E-02073
XTurb7670,A/B,AA,Filo067E-02075
XTurb7670,A/B,AA,Filo067E-02076
XTurb7670,A/B,AA,Filo067E-02083
XTurb7670,A/B,AA,Filo067E-02084
XTurb7670,A/B,AA,Filo067E-02086

This User Gave Thanks to Don Cragun For This Post:

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

UNIX for Dummies Questions & Answers

Custom sort on a column

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort file data according to a custom list of string

Discussion started by: mohtashims

2. Shell Programming and Scripting

Use sort to sort numerical column

Discussion started by: sand1234

3. UNIX for Beginners Questions & Answers

How do I custom sort the files in a directory using the filenames in a text file.?

Discussion started by: KMusunuru

4. Shell Programming and Scripting

Sort and Split file with header and custom name

Discussion started by: Saanvi1

5. Shell Programming and Scripting

Find and sort by first column value

Discussion started by: f_o_555

6. Shell Programming and Scripting

Sort on column

Discussion started by: samrat dutta

7. UNIX for Dummies Questions & Answers

Sort command in one column and not effect to another column

Discussion started by: GeodusT

8. UNIX for Dummies Questions & Answers

Sort on one column only

Discussion started by: gio001

9. Shell Programming and Scripting

sort on second column only based on first column

Discussion started by: malcomex999

10. Shell Programming and Scripting

Question about sort specific column and print other column at the same time !

Discussion started by: patrick87