Sort help on non numeric field Post: 302531852

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

Sort alpha on 1st field, numerical on 2nd field (sci notation)

I want to sort alphabetically on the first field and sort in descending numerical order on the 2nd field. With a normal "sort -r -n" it does this: abc ||| 5e-05 ||| bla abc ||| 3 ||| ble def ||| 1 ||| abc def ||| 0.2 ||| def As you can see it ignores the fact that 5e-05 is actually 0.00005...

4. Linux

Using sort command to get numeric ascending order

HI everyone, I am trying to use the unix sort command to get a list of numbers sorted in ascending order but having trouble in getting it to work. An example of this issue would be when i am trying to sort the following three number each on a different line "1" , "2" and "116" the sort command...

5. Shell Programming and Scripting

Perl script to sort data on second numeric field

Hi, I'm a learner of PERL programming. I've a input file with the below data: SWAT_5, 1703, 2010-09-21 SWAT_6, 2345, 2010-09-21 SWAT_7, 1792, 2010-09-21 SWAT_8, 1662, 2010-09-21 SWAT_9, 1888, 2010-09-21 VXHARP_1, 171, 2010-09-21 I need to sort this data based on the second...

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

[Solved] sort on numeric part of field

I have ran into a heavy case of PEBCAK*) and could need some advice on what i do wrong: OS is Linux (kernel 2.6.35), sort --version reports "8.5" from 2010, shell is ksh. Originally i had a file with with the following structure: hdisk1 yyy hdisk2 yyy hdisk3 yyy hdisk4 yyy hdisk5 yyy...

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

10. UNIX for Advanced & Expert Users

Sort by second column numeric values

From googling and reading man pages I figured out this sorts the first column by numeric values. sort -g -k 1,1 Why does the -n option not work? The man pages were a bit confusing. And what if I want to sort the second column numerically? I haven't been able to figure that out. The file...

LEARN ABOUT CENTOS

datetime::locale::om

DateTime::Locale::om(3) 				User Contributed Perl Documentation				   DateTime::Locale::om(3)

NAME

       DateTime::Locale::om

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'om' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Oromo.

DATA

       This locale inherits from the DateTime::Locale::root locale.

       It contains the following data.

   Days
       Wide (format)

	 Wiixata
	 Qibxata
	 Roobii
	 Kamiisa
	 Jimaata
	 Sanbata
	 Dilbata

       Abbreviated (format)

	 Wix
	 Qib
	 Rob
	 Kam
	 Jim
	 San
	 Dil

       Narrow (format)

	 M
	 T
	 W
	 T
	 F
	 S
	 S

       Wide (stand-alone)

	 Wiixata
	 Qibxata
	 Roobii
	 Kamiisa
	 Jimaata
	 Sanbata
	 Dilbata

       Abbreviated (stand-alone)

	 Wix
	 Qib
	 Rob
	 Kam
	 Jim
	 San
	 Dil

       Narrow (stand-alone)

	 M
	 T
	 W
	 T
	 F
	 S
	 S

   Months
       Wide (format)

	 Amajjii
	 Guraandhala
	 Bitooteessa
	 Elba
	 Caamsa
	 Waxabajjii
	 Adooleessa
	 Hagayya
	 Fuulbana
	 Onkololeessa
	 Sadaasa
	 Muddee

       Abbreviated (format)

	 Ama
	 Gur
	 Bit
	 Elb
	 Cam
	 Wax
	 Ado
	 Hag
	 Ful
	 Onk
	 Sad
	 Mud

       Narrow (format)

	 J
	 F
	 M
	 A
	 M
	 J
	 J
	 A
	 S
	 O
	 N
	 D

       Wide (stand-alone)

	 Amajjii
	 Guraandhala
	 Bitooteessa
	 Elba
	 Caamsa
	 Waxabajjii
	 Adooleessa
	 Hagayya
	 Fuulbana
	 Onkololeessa
	 Sadaasa
	 Muddee

       Abbreviated (stand-alone)

	 Ama
	 Gur
	 Bit
	 Elb
	 Cam
	 Wax
	 Ado
	 Hag
	 Ful
	 Onk
	 Sad
	 Mud

       Narrow (stand-alone)

	 J
	 F
	 M
	 A
	 M
	 J
	 J
	 A
	 S
	 O
	 N
	 D

   Quarters
       Wide (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BCE
	 CE

       Abbreviated

	 KD
	 KB

       Narrow

	 KD
	 KB

   Date Formats
       Full

	  2008-02-05T18:30:30 = Qibxata, Guraandhala 5, 2008
	  1995-12-22T09:05:02 = Jimaata, Muddee 22, 1995
	 -0010-09-15T04:44:23 = Sanbata, Fuulbana 15, -10

       Long

	  2008-02-05T18:30:30 = 05 Guraandhala 2008
	  1995-12-22T09:05:02 = 22 Muddee 1995
	 -0010-09-15T04:44:23 = 15 Fuulbana -10

       Medium

	  2008-02-05T18:30:30 = 05-Gur-2008
	  1995-12-22T09:05:02 = 22-Mud-1995
	 -0010-09-15T04:44:23 = 15-Ful--10

       Short

	  2008-02-05T18:30:30 = 05/02/08
	  1995-12-22T09:05:02 = 22/12/95
	 -0010-09-15T04:44:23 = 15/09/-10

       Default

	  2008-02-05T18:30:30 = 05-Gur-2008
	  1995-12-22T09:05:02 = 22-Mud-1995
	 -0010-09-15T04:44:23 = 15-Ful--10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 6:30:30 WB UTC
	  1995-12-22T09:05:02 = 9:05:02 WD UTC
	 -0010-09-15T04:44:23 = 4:44:23 WD UTC

       Long

	  2008-02-05T18:30:30 = 6:30:30 WB UTC
	  1995-12-22T09:05:02 = 9:05:02 WD UTC
	 -0010-09-15T04:44:23 = 4:44:23 WD UTC

       Medium

	  2008-02-05T18:30:30 = 6:30:30 WB
	  1995-12-22T09:05:02 = 9:05:02 WD
	 -0010-09-15T04:44:23 = 4:44:23 WD

       Short

	  2008-02-05T18:30:30 = 6:30 WB
	  1995-12-22T09:05:02 = 9:05 WD
	 -0010-09-15T04:44:23 = 4:44 WD

       Default

	  2008-02-05T18:30:30 = 6:30:30 WB
	  1995-12-22T09:05:02 = 9:05:02 WD
	 -0010-09-15T04:44:23 = 4:44:23 WD

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = Qibxata, Guraandhala 5, 2008 6:30:30 WB UTC
	  1995-12-22T09:05:02 = Jimaata, Muddee 22, 1995 9:05:02 WD UTC
	 -0010-09-15T04:44:23 = Sanbata, Fuulbana 15, -10 4:44:23 WD UTC

       Long

	  2008-02-05T18:30:30 = 05 Guraandhala 2008 6:30:30 WB UTC
	  1995-12-22T09:05:02 = 22 Muddee 1995 9:05:02 WD UTC
	 -0010-09-15T04:44:23 = 15 Fuulbana -10 4:44:23 WD UTC

       Medium

	  2008-02-05T18:30:30 = 05-Gur-2008 6:30:30 WB
	  1995-12-22T09:05:02 = 22-Mud-1995 9:05:02 WD
	 -0010-09-15T04:44:23 = 15-Ful--10 4:44:23 WD

       Short

	  2008-02-05T18:30:30 = 05/02/08 6:30 WB
	  1995-12-22T09:05:02 = 22/12/95 9:05 WD
	 -0010-09-15T04:44:23 = 15/09/-10 4:44 WD

       Default

	  2008-02-05T18:30:30 = 05-Gur-2008 6:30:30 WB
	  1995-12-22T09:05:02 = 22-Mud-1995 9:05:02 WD
	 -0010-09-15T04:44:23 = 15-Ful--10 4:44:23 WD

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 Qib
	  1995-12-22T09:05:02 = 22 Jim
	 -0010-09-15T04:44:23 = 15 San

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 WB
	  1995-12-22T09:05:02 = 9:05 WD
	 -0010-09-15T04:44:23 = 4:44 WD

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 WB
	  1995-12-22T09:05:02 = 9:05:02 WD
	 -0010-09-15T04:44:23 = 4:44:23 WD

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = Qib, 2-5
	  1995-12-22T09:05:02 = Jim, 12-22
	 -0010-09-15T04:44:23 = San, 9-15

       MMdd (dd/MM)

	  2008-02-05T18:30:30 = 05/02
	  1995-12-22T09:05:02 = 22/12
	 -0010-09-15T04:44:23 = 15/09

       MMM (LLL)

	  2008-02-05T18:30:30 = Gur
	  1995-12-22T09:05:02 = Mud
	 -0010-09-15T04:44:23 = Ful

       MMMd (MMM d)

	  2008-02-05T18:30:30 = Gur 5
	  1995-12-22T09:05:02 = Mud 22
	 -0010-09-15T04:44:23 = Ful 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = Qib Gur 5
	  1995-12-22T09:05:02 = Jim Mud 22
	 -0010-09-15T04:44:23 = San Ful 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = Guraandhala 5
	  1995-12-22T09:05:02 = Muddee 22
	 -0010-09-15T04:44:23 = Fuulbana 15

       MMMMdd (dd MMMM)

	  2008-02-05T18:30:30 = 05 Guraandhala
	  1995-12-22T09:05:02 = 22 Muddee
	 -0010-09-15T04:44:23 = 15 Fuulbana

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = Qib Guraandhala 5
	  1995-12-22T09:05:02 = Jim Muddee 22
	 -0010-09-15T04:44:23 = San Fuulbana 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = Qib, 2008-2-5
	  1995-12-22T09:05:02 = Jim, 1995-12-22
	 -0010-09-15T04:44:23 = San, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 Gur
	  1995-12-22T09:05:02 = 1995 Mud
	 -0010-09-15T04:44:23 = -10 Ful

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = Qib, 2008 Gur 5
	  1995-12-22T09:05:02 = Jim, 1995 Mud 22
	 -0010-09-15T04:44:23 = San, -10 Ful 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 Guraandhala
	  1995-12-22T09:05:02 = 1995 Muddee
	 -0010-09-15T04:44:23 = -10 Fuulbana

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

       yyMM (MM/yy)

	  2008-02-05T18:30:30 = 02/08
	  1995-12-22T09:05:02 = 12/95
	 -0010-09-15T04:44:23 = 09/-10

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyyyMMMM (MMMM y)

	  2008-02-05T18:30:30 = Guraandhala 2008
	  1995-12-22T09:05:02 = Muddee 1995
	 -0010-09-15T04:44:23 = Fuulbana -10

   Miscellaneous
       Prefers 24 hour time?

       No

       Local first day of the week

       Wiixata

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.16.3							    2014-06-10						   DateTime::Locale::om(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

Sort alpha on 1st field, numerical on 2nd field (sci notation)

Discussion started by: FrancoisCN

4. Linux

Using sort command to get numeric ascending order

Discussion started by: wali4813