Sort by second column numeric values Post: 302960426

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to numeric sort on field time

i want to sort time field given by who command as a whole i have tried like this who|sort -n +4 -5

2. Shell Programming and Scripting

Numeric sort error

Hello all I have data like below where the column with values (PRI, SEC ) is the char field and the rest are Numeric Fields. 200707,9580,58,7,2,1,PRI,1,1,137,205594,0,5,10,-45.51,-45.51 200707,9580,58,7,2,1,SEC,1,1,137,205594,0,5,10,-45.51,45.51...

3. Shell Programming and Scripting

How to sort values inside one column?

Hi, Could someone please help me with this? I have a text file that has fields seperated by comma. The last column in it has multiple values seperated by "|". I need to sort values in the last column seperated by pipe..is there any way I can do this through script? Sample text file - ...

4. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Hi All, I have a file which is having 3 columns as (string string integer) a b 1 x y 2 p k 5 y y 4 ..... ..... Question: I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the...

5. Shell Programming and Scripting

Sort help on non numeric field

Hi, I am unable to sort data on the first field $cat t Jim,212121,Seattle Bill,404404,Seattle Steve,246810,Nevada Scott,212277,LosAngeles Jim,212121,Ohio sort -t"," -k1,2 t Bill,404404,Seattle Jim,212121,Ohio Jim,212121,Seattle Scott,212277,LosAngeles Steve,246810,Nevada

6. UNIX for Dummies Questions & Answers

sort files by numeric filename

dear all, i have .dat files named as: 34.dat 2.dat 16.dat 107.dat i would like to sort them by their filenames as: 2.dat 16.dat 34.dat 107.dat i have tried numerous combinations of sort and ls command (in vain) to obtain : 107.dat 16.dat 2.dat 34.dat

7. Shell Programming and Scripting

Sort numeric order

Hi I am using this cat substitutionFeats.txt | gawk '{$0=gensub(/\t/,"blabla",1);print}' | gawk '{print length, $0}' | sort -n | sort -r and the "sort -n" command doesn't work as expected: it leads to a wrong ordering: 64 Adjustable cuffs 64 Abrasion- 64 Abrasion pas 647 Sanitized 647...

8. Shell Programming and Scripting

Help with sort word and general numeric sort at the same time

Input file: 100%ABC2 3.44E-12 USA A2M%H02579 0E0 UK 100%ABC2 5.34E-8 UK 100%ABC2 3.25E-12 USA A2M%H02579 5E-45 UK Output file: 100%ABC2 3.44E-12 USA 100%ABC2 3.25E-12 USA 100%ABC2 5.34E-8 UK A2M%H02579 0E0 UK A2M%H02579 5E-45 UK Code try: sort -k1,1 -g -k2 -r input.txt...

9. Shell Programming and Scripting

Splitting the numeric vs alpha values in a column to distinct columns

How could i take an input file and split the numeric values from the alpha values (123 vs abc) to distinc columns, and if the source is blank to keep it blank (null) in both of the new columns: So if the source file had a column like: Value: |1 | |2.3| | | |No| I would...

10. UNIX for Beginners Questions & Answers

Replace a numeric values in a certain column

Hi All, I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7 I tried awk '{gsub("8","7",$35)}1' infile > outfile ----> not working sed -i 's/8/7'g' infile --- it is replacing all...

LEARN ABOUT DEBIAN

slamrg

slamrg.f(3)							      LAPACK							       slamrg.f(3)

NAME

       slamrg.f -

SYNOPSIS

   Functions/Subroutines
       subroutine slamrg (N1, N2, A, STRD1, STRD2, INDEX)
	   SLAMRG

Function/Subroutine Documentation
   subroutine slamrg (integerN1, integerN2, real, dimension( * )A, integerSTRD1, integerSTRD2, integer, dimension( * )INDEX)
       SLAMRG

       Purpose:

	    SLAMRG will create a permutation list which will merge the elements
	    of A (which is composed of two independently sorted sets) into a
	    single set which is sorted in ascending order.

       Parameters:
	   N1

		     N1 is INTEGER

	   N2

		     N2 is INTEGER
		    These arguements contain the respective lengths of the two
		    sorted lists to be merged.

	   A

		     A is REAL array, dimension (N1+N2)
		    The first N1 elements of A contain a list of numbers which
		    are sorted in either ascending or descending order.  Likewise
		    for the final N2 elements.

	   STRD1

		     STRD1 is INTEGER

	   STRD2

		     STRD2 is INTEGER
		    These are the strides to be taken through the array A.
		    Allowable strides are 1 and -1.  They indicate whether a
		    subset of A is sorted in ascending (STRDx = 1) or descending
		    (STRDx = -1) order.

	   INDEX

		     INDEX is INTEGER array, dimension (N1+N2)
		    On exit this array will contain a permutation such that
		    if B( I ) = A( INDEX( I ) ) for I=1,N1+N2, then B will be
		    sorted in ascending order.

       Author:
	   Univ. of Tennessee

	   Univ. of California Berkeley

	   Univ. of Colorado Denver

	   NAG Ltd.

       Date:
	   November 2011

       Definition at line 100 of file slamrg.f.

Author
       Generated automatically by Doxygen for LAPACK from the source code.

Version 3.4.1							  Sun May 26 2013						       slamrg.f(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to numeric sort on field time

Discussion started by: rahulspatil_111

2. Shell Programming and Scripting

Numeric sort error

Discussion started by: vasuarjula

3. Shell Programming and Scripting

How to sort values inside one column?

Discussion started by: sncoupons

4. Shell Programming and Scripting

print unique values of a column and sum up the corresponding values in next column

Discussion started by: amigarus