Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help with sort First Column followed by Second Column

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with sort First Column followed by Second Column
# 1  
Old 05-03-2016
Help with sort First Column followed by Second Column
Input file:
Code:
DN63688_c0_g1   DN63688_c0_g1_i1
DN71_c0_g1      DN71_c0_g1_i1
DN63688_c0_g1   DN63688_c0_g1_i2
DN63688_c0_g1   DN63688_c0_g1_i3
DN63688_c0_g1   DN63688_c0_g1_i7
DN134_c0_g1     DN134_c0_g1_i1
DN63688_c0_g1   DN63688_c0_g1_i8
DN63688_c0_g1   DN63688_c0_g1_i9
DN63688_c0_g1   DN63688_c0_g1_i10
DN63688_c0_g1   DN63688_c0_g1_i11
DN63688_c0_g1   DN63688_c0_g1_i12
DN133_c0_g1     DN133_c0_g1_i1
DN63688_c0_g1   DN63688_c0_g1_i13
DN63688_c0_g1   DN63688_c0_g1_i14
DN63688_c0_g1   DN63688_c0_g1_i15
DN63688_c0_g1   DN63688_c0_g1_i20
DN63688_c0_g1   DN63688_c0_g1_i21
.
.

Desired Output:
Code:
DN71_c0_g1      DN71_c0_g1_i1
DN133_c0_g1     DN133_c0_g1_i1
DN134_c0_g1     DN134_c0_g1_i1
DN63688_c0_g1   DN63688_c0_g1_i1
DN63688_c0_g1   DN63688_c0_g1_i2
DN63688_c0_g1   DN63688_c0_g1_i3
DN63688_c0_g1   DN63688_c0_g1_i7
DN63688_c0_g1   DN63688_c0_g1_i8
DN63688_c0_g1   DN63688_c0_g1_i9
DN63688_c0_g1   DN63688_c0_g1_i10
DN63688_c0_g1   DN63688_c0_g1_i11
DN63688_c0_g1   DN63688_c0_g1_i12
DN63688_c0_g1   DN63688_c0_g1_i13
DN63688_c0_g1   DN63688_c0_g1_i14
DN63688_c0_g1   DN63688_c0_g1_i15
DN63688_c0_g1   DN63688_c0_g1_i20
DN63688_c0_g1   DN63688_c0_g1_i21
.
.

Command try:
Code:
sort -T . -k1.3n -t_ -k6 Input_File
DN71_c0_g1      DN71_c0_g1_i1
DN133_c0_g1     DN133_c0_g1_i1
DN134_c0_g1     DN134_c0_g1_i1
DN63688_c0_g1   DN63688_c0_g1_i1
DN63688_c0_g1   DN63688_c0_g1_i10
DN63688_c0_g1   DN63688_c0_g1_i11
DN63688_c0_g1   DN63688_c0_g1_i12
DN63688_c0_g1   DN63688_c0_g1_i13
DN63688_c0_g1   DN63688_c0_g1_i14
DN63688_c0_g1   DN63688_c0_g1_i15
DN63688_c0_g1   DN63688_c0_g1_i2
DN63688_c0_g1   DN63688_c0_g1_i20
DN63688_c0_g1   DN63688_c0_g1_i21
DN63688_c0_g1   DN63688_c0_g1_i3
DN63688_c0_g1   DN63688_c0_g1_i7
DN63688_c0_g1   DN63688_c0_g1_i8
DN63688_c0_g1   DN63688_c0_g1_i9
.
.

I wanna sort the number after DNX at first column from smallest to largest then followed by sort the number _iX after at second column from smallest to largest too.

Thanks for any advice.
Last edited by perl_beginner; 05-04-2016 at 12:19 AM..
# 2  
Old 05-04-2016
try:
Code:
 sort -T . -k3n -t_ -k7 infile > outfile

I get:
Code:
$ sort -T . -k3n -t_ -k7 filename
DN133_c0_g1     DN133_c0_g1_i1
DN134_c0_g1     DN134_c0_g1_i1
DN63688_c0_g1   DN63688_c0_g1_i1
DN63688_c0_g1   DN63688_c0_g1_i10
DN63688_c0_g1   DN63688_c0_g1_i11
DN63688_c0_g1   DN63688_c0_g1_i12
DN63688_c0_g1   DN63688_c0_g1_i13
DN63688_c0_g1   DN63688_c0_g1_i14
DN63688_c0_g1   DN63688_c0_g1_i15
DN63688_c0_g1   DN63688_c0_g1_i2
DN63688_c0_g1   DN63688_c0_g1_i20
DN63688_c0_g1   DN63688_c0_g1_i21
DN63688_c0_g1   DN63688_c0_g1_i3
DN63688_c0_g1   DN63688_c0_g1_i7
DN63688_c0_g1   DN63688_c0_g1_i8
DN63688_c0_g1   DN63688_c0_g1_i9
DN71_c0_g1      DN71_c0_g1_i1

FWIW -T. may not help performance if the disk is busy. By default sort uses TMPDIR, so using one of the kernel "filesystems" is usually a better choice.
This User Gave Thanks to jim mcnamara For This Post:
perl_beginner
# 3  
Old 05-04-2016
Try:
Code:
sort -T . -k1.3n -t_ -k6.2n Input_File

This User Gave Thanks to Don Cragun For This Post:
perl_beginner
# 4  
Old 05-04-2016
Thanks to solve my doubt Smilie

---------- Post updated at 10:20 PM ---------- Previous update was at 10:20 PM ----------

Thanks a lot Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Use sort to sort numerical column

How to sort the following output based on lowest to highest BE? The following sort does not work. $ sort -t. -k1,1n -k2,2n bfd.txt BE31.116 0s 0s DOWN DAMP BE31.116 0s 0s DOWN DAMP BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 Replies

2. Shell Programming and Scripting

Sort on column

How to sort based on the 4 the column . The input data has a header and output needs to be sorted based on the 4th column rbcid. I tried below code but not getting results sort -u -t'|' -k4,4r file1 > file2 time|tourit|nofdays|rbcid|blank|type|value|nill|valuedesc|name... (6 Replies)
Discussion started by: samrat dutta
6 Replies

3. Shell Programming and Scripting

Difference of the same column when two other column matches and one column differs less than 1 hour

This is my input file : # cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9 This is the required output ... (1 Reply)
Discussion started by: Lakshmikumari
1 Replies

4. UNIX for Dummies Questions & Answers

Sort command in one column and not effect to another column

If my data is numerical : 1 = 101 2 = 102 3 = 104 4 = 104 7 = 103 8 = 103 9 = 105 I need the result like below: 1 = 101 2 = 102 3 = 103 4 = 103 7 = 104 8 = 104 9 = 105 (4 Replies)
Discussion started by: GeodusT
4 Replies

5. Shell Programming and Scripting

Edit column using sort

Hi Expert, Please kindly need your help, I dont have any idea how to make this input to be as output. Thanks before $ more input.dat @zmap_fault HEADER , FALT, 80, 1 X (EASTING) , 1, 1, 1, 1, 15, 7, 0.1000000E+31, , 15, 7, 0 Y... (5 Replies)
Discussion started by: ipatah
5 Replies

6. UNIX for Dummies Questions & Answers

Sort on one column only

Hello, I am running on AIX.I have a question about sorting in UNIX. if my file is something like this: a c b d a b b c a a I want to sort on column 1 only. The following statement does not seem to work, it still considers the rest of the line in the sorting results: sort... (2 Replies)
Discussion started by: gio001
2 Replies

7. Shell Programming and Scripting

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2 file 1 sample SNDK 80004C101 AT XLNX 983919101 BB NETL 64118B100 BS AMD 007903107 CC KLAC 482480100 DC TER 880770102 KATS ATHR 04743P108 KATS... (7 Replies)
Discussion started by: rydz00
7 Replies

8. Shell Programming and Scripting

sort on second column only based on first column

I have an input file like this... AAAlkalines Energizer AAAlkalines Energizer AAAlkalines Energizer AAAlkalines Sunlight AAAlkalines Sunlight AAAlkalines Sunlight AAAlkalines Energizer AAAlkalines Energizer AAAlkalines Energizer AAASalines ... (7 Replies)
Discussion started by: malcomex999
7 Replies

9. Shell Programming and Scripting

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

Hi, This is my input file: ali 5 usa abc abu 4 uk bca alan 6 brazil bac pinky 10 utah sdc My desired output: pinky 10 utah sdc alan 6 brazil bac ali 5 usa abc abu 4 uk bca Based on the column two, I want to do the descending order and print out other related column at the... (3 Replies)
Discussion started by: patrick87
3 Replies

10. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12... (5 Replies)
Discussion started by: manneni prakash
5 Replies
Login or Register to Ask a Question