Sort based on one column Post: 303041927

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Sort based on one column Post 303041927 by kshitij on Saturday 7th of December 2019 07:32:36 AM

12-07-2019

Registered User

Sort based on one column

Hi All ,

I am having an input file like this

Input file

Code:

7 sks/jsjssj/ddjd/hjdjd/hdhd/Q 10 0.5 13 
    dkdkd/djdjd/djdjd/djd/QB 01 0.5 
    ldld/dkd/jdf/fjfjf/fjf/Q 0.5 
10 sjs/jsdd/djdkd/dhd/Q 01 0.5 21 
     kdkd/djdd/djdd/jdd/djd/QB 01 0.5 
     dkdld/djdjd/djd/Q 01 0.5 
     djd/jdkd/djd/djd/Qb 01 0.5 
19 dd/jdddjd/djd/djd/d/Q 10 0.5 100
    djd/jhd/jhd/jd/jd/Qb 10 0.5 
     djd/djd/djd/djd/djd/dj 01 0.5

I need to sort the file based on last column and this should be my output file

Output file

Code:

19 dd/jdddjd/djd/djd/d/Q 10 0.5 100
    djd/jhd/jhd/jd/jd/Qb 10 0.5 
     djd/djd/djd/djd/djd/dj 01 0.5 
  10 sjs/jsdd/djdkd/dhd/Q 01 0.5 21 
     kdkd/djdd/djdd/jdd/djd/QB 01 0.5 
     dkdld/djdjd/djd/Q 01 0.5 
     djd/jdkd/djd/djd/Qb 01 0.5
   7 sks/jsjssj/ddjd/hjdjd/hdhd/Q 10 0.5 13 
    dkdkd/djdjd/djdjd/djd/QB 01 0.5 
    ldld/dkd/jdf/fjfjf/fjf/Q 0.5

From Largest to smallest 5th COlumn

When I tried to use this command
sort -u -k5 input , it is disturbing other columns as well
All the columns should be sorted based on the 5th column but its not happening .

Last edited by RavinderSingh13; 12-07-2019 at 09:26 AM..

kshitij

View Public Profile for kshitij

Find all posts by kshitij

10 More Discussions You Might Find Interesting

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

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

3. Shell Programming and Scripting

Sort file based on column

Hi, My input file is $cat samp 1 siva 1 raja 2 siva 1 siva 2 raja 4 venkat i want sort this name wise...alos need to remove duplicate lines. i am using cat samp|awk '{print $2,$1}'|sort -u it showing raja 1

4. UNIX for Dummies Questions & Answers

How to sort a column based on numerical ascending order if it includes e-10?

I have a column of numbers in the following format: 1.722e-05 2.018e-05 2.548e-05 2.747e-05 7.897e-05 4.016e-05 4.613e-05 4.613e-05 5.151e-05 5.151e-05 5.151e-05 6.1e-05 6.254e-05 7.04e-05 7.12e-05 7.12e-05

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

6. Shell Programming and Scripting

Sort based on column 1, not working with awk

Hi Guru, I need some help regarding awking the output so it only show the first line (based on column) of each row. So If column has 1, three row, then it only show the first line of that row, based on similar character in column 1. So i am trying to achieve a sort, based on column one and...

7. Shell Programming and Scripting

Sort based on certain value in a column

Hi, i need to sort content of files based on a specific value. An example as below. Input1.txt Col_1 SW_MH2_ST ST_F72_9S SW_MH3_S6 Col_2 SW_MH3_AS7 ST_S15_9CH SW_MH3_AS8 SW_MH3_ST Col_3 ST_M93_SZ ST_C16_TC

8. Shell Programming and Scripting

Sum column values based in common identifier in 1st column.

Hi, I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column) The input is for example, after sorted: K00001 1 1 4 3...

9. UNIX for Beginners Questions & Answers

How to align/sort the column pairs of an csv file, based on keyword word specified in another file?

I have a csv file as shown below, xop_thy 80 avr_njk 50 str_nyu 60 avr_irt 70 str_nhj 60 avr_ngt 50 str_tgt 80 xop_nmg 50 xop_nth 40 cyv_gty 40 cop_thl 40 vir_tyk 80 vir_plo 20 vir_thk 40 ijk_yuc 70 cop_thy 70 ijk_yuc 80 irt_hgt 80 I need to align/sort the csv file based...

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

LEARN ABOUT DEBIAN

colrm

COLRM(1)						    BSD General Commands Manual 						  COLRM(1)

NAME

     colrm -- remove columns from a file

SYNOPSIS

     colrm [start [stop]]

DESCRIPTION

     The colrm utility removes selected columns from the lines of a file.  A column is defined as a single character in a line.  Input is read
     from the standard input.  Output is written to the standard output.

     If only the start column is specified, columns numbered less than the start column will be written.  If both start and stop columns are spec-
     ified, columns numbered less than the start column or greater than the stop column will be written.  Column numbering starts with one, not
     zero.

     Tab characters increment the column count to the next multiple of eight.  Backspace characters decrement the column count by one.

ENVIRONMENT

     The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).

EXIT STATUS

     The colrm utility exits 0 on success, and >0 if an error occurs.

SEE ALSO

     awk(1), column(1), cut(1), paste(1)

HISTORY

     The colrm command appeared in 3.0BSD.

BSD
								  August 4, 2004							       BSD

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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

Discussion started by: patrick87

2. Shell Programming and Scripting

sort on second column only based on first column

Discussion started by: malcomex999

3. Shell Programming and Scripting

Sort file based on column

Discussion started by: rsivasan

4. UNIX for Dummies Questions & Answers

How to sort a column based on numerical ascending order if it includes e-10?

Discussion started by: evelibertine