Sponsored Content
Top Forums Shell Programming and Scripting Help with sort First Column followed by Second Column Post 302972293 by perl_beginner on Tuesday 3rd of May 2016 10:21:00 PM
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..
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
cgbequ.f(3)							      LAPACK							       cgbequ.f(3)

NAME
cgbequ.f - SYNOPSIS
Functions/Subroutines subroutine cgbequ (M, N, KL, KU, AB, LDAB, R, C, ROWCND, COLCND, AMAX, INFO) CGBEQU Function/Subroutine Documentation subroutine cgbequ (integerM, integerN, integerKL, integerKU, complex, dimension( ldab, * )AB, integerLDAB, real, dimension( * )R, real, dimension( * )C, realROWCND, realCOLCND, realAMAX, integerINFO) CGBEQU Purpose: CGBEQU computes row and column scalings intended to equilibrate an M-by-N band matrix A and reduce its condition number. R returns the row scale factors and C the column scale factors, chosen to try to make the largest element in each row and column of the matrix B with elements B(i,j)=R(i)*A(i,j)*C(j) have absolute value 1. R(i) and C(j) are restricted to be between SMLNUM = smallest safe number and BIGNUM = largest safe number. Use of these scaling factors is not guaranteed to reduce the condition number of A but works well in practice. Parameters: M M is INTEGER The number of rows of the matrix A. M >= 0. N N is INTEGER The number of columns of the matrix A. N >= 0. KL KL is INTEGER The number of subdiagonals within the band of A. KL >= 0. KU KU is INTEGER The number of superdiagonals within the band of A. KU >= 0. AB AB is COMPLEX array, dimension (LDAB,N) The band matrix A, stored in rows 1 to KL+KU+1. The j-th column of A is stored in the j-th column of the array AB as follows: AB(ku+1+i-j,j) = A(i,j) for max(1,j-ku)<=i<=min(m,j+kl). LDAB LDAB is INTEGER The leading dimension of the array AB. LDAB >= KL+KU+1. R R is REAL array, dimension (M) If INFO = 0, or INFO > M, R contains the row scale factors for A. C C is REAL array, dimension (N) If INFO = 0, C contains the column scale factors for A. ROWCND ROWCND is REAL If INFO = 0 or INFO > M, ROWCND contains the ratio of the smallest R(i) to the largest R(i). If ROWCND >= 0.1 and AMAX is neither too large nor too small, it is not worth scaling by R. COLCND COLCND is REAL If INFO = 0, COLCND contains the ratio of the smallest C(i) to the largest C(i). If COLCND >= 0.1, it is not worth scaling by C. AMAX AMAX is REAL Absolute value of largest matrix element. If AMAX is very close to overflow or very close to underflow, the matrix should be scaled. INFO INFO is INTEGER = 0: successful exit < 0: if INFO = -i, the i-th argument had an illegal value > 0: if INFO = i, and i is <= M: the i-th row of A is exactly zero > M: the (i-M)-th column of A is exactly zero Author: Univ. of Tennessee Univ. of California Berkeley Univ. of Colorado Denver NAG Ltd. Date: November 2011 Definition at line 154 of file cgbequ.f. Author Generated automatically by Doxygen for LAPACK from the source code. Version 3.4.1 Sun May 26 2013 cgbequ.f(3)
All times are GMT -4. The time now is 02:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy