Help with sort command Post: 302589080

Sponsored Content

Top Forums Shell Programming and Scripting Help with sort command Post 302589080 by Chubler_XL on Tuesday 10th of January 2012 06:38:56 PM

01-10-2012

Moderator

Because you are sorting on these values:

Code:

11 14,12,08
11 14,04,12
11 14,07,46
11 14,18,50
12 13,58,08
12 14,14,18
12 14,13,27
12 14,11,43
12 16,57,45

The month in your data file is in short name format, so it will be hard to use sort to get it in proper date order. Have you considered numeric format for the month?

If you're stuck with that format you might have to do something horrible like this:

Code:

sed \
-e 's/-jan-/-01jan-/' \
-e 's/-feb-/-02feb-/' \
-e 's/-mar-/-03mar-/' \
-e 's/-apr-/-04apr-/' \
-e 's/-may-/-05may-/' \
-e 's/-jun-/-06jun-/' \
-e 's/-jul-/-07jul-/' \
-e 's/-aug-/-08aug-/' \
-e 's/-sep-/-09sep-/' \
-e 's/-oct-/-10oct-/' \
-e 's/-nov-/-11nov-/' \
-e 's/-dec-/-12dec-/' test | sort -t, -k 5.12,5.13 -k 5.4,5.5 -k 5.1,5.2 -k 5.15,5.22 | sed \
-e 's/-01jan-/-jan-/' \
-e 's/-02feb-/-feb-/' \
-e 's/-03mar-/-mar-/' \
-e 's/-04apr-/-apr-/' \
-e 's/-05may-/-may-/' \
-e 's/-06jun-/-jun-/' \
-e 's/-07jul-/-jul-/' \
-e 's/-08aug-/-aug-/' \
-e 's/-09sep-/-sep-/' \
-e 's/-10oct-/-oct-/' \
-e 's/-11nov-/-nov-/' \
-e 's/-12dec-/-dec-/'

Last edited by Chubler_XL; 01-10-2012 at 07:48 PM..

This User Gave Thanks to Chubler_XL For This Post:

Chubler_XL

View Public Profile for Chubler_XL

Find all posts by Chubler_XL

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help with the Sort command

Can someone please tell me how to sort a file, based on a particular position within the file? I have a line sequential file that is 152 bytes per record, in which i need to sort the file based on the numeric data in positions 142-152. I have done the "man sort" command and see the -k option...

2. UNIX for Dummies Questions & Answers

sort command

Hi, I am going to sort a huge flat file using sort command, this file is about 36 million lines, 179 fields delimitered by Ctrl B (002). eg. 1^B198709..... 17^B200301.... 3^B196511.... ..... I want this file being sorted by the first field, the result is like : 1^B198709........

3. UNIX for Dummies Questions & Answers

sort command...

Hi I�d like to get a few explanations about how the sort command works when cascading the options. cscyabl@comet:(develop)> more file 2:A2 2:A1 5:A2 5:A2 10:A1 cscyabl@comet:(develop)> sort -n -u file 2:A1 5:A2 10:A1 cscyabl@comet:(develop)> sort -u -n file 2:A1 5:A2 10:A1...

4. Shell Programming and Scripting

Need help with sort command

Hi i have a file containing ip addresses and want to sort those IP addresses in the ascending order. file (match.txt) contents are: 192.168.0.100 192.168.0.16 192.168.0.10 192.168.0.23 192.168.0.2 192.168.0.3 192.168.0.1 192.168.0.222 i tried: sort -n match.txt output is :...

5. Shell Programming and Scripting

How to Sort Floating Numbers Using the Sort Command?

Hi to all. I'm trying to sort this with the Unix command sort. user1:12345678:3.5:2.5:8:1:2:3 user2:12345679:4.5:3.5:8:1:3:2 user3:12345687:5.5:2.5:6:1:3:2 user4:12345670:5.5:2.5:5:3:2:1 user5:12345671:2.5:5.5:7:2:3:1 I need to get this: user3:12345687:5.5:2.5:6:1:3:2...

6. Homework & Coursework Questions

Sort command

I have file ipaddress.txt 192.168.1.25 127.3.9.12 192.168.12.1 127.21.2.3 127.92.80.6 192.168.4.5 I want to sort as 127.3.9.12 127.21.2.3 127.92.80.6 192.168.1.25 192.168.12.1 192.168.4.5 So what sort command do I have to use.

7. Shell Programming and Scripting

Is it Possible to sort a list of hexadecimal numbers using "sort" command?

Hello Everybody :) !!!. i have question in mind, is it possible to sort a list of hexadecimal numbers using "sort" command?

8. Shell Programming and Scripting

Help to sort out... Possible use of sort command

I have an input like 4.3.6.66 4.3.6.67 4.3.6.70 4.3.6.25 4.3.6.15 4.3.6.54 4.3.6.44 4.3.6.34 4.3.6.24 4.3.6.14 4.3.6.53 4.3.6.43 4.3.6.49 4.3.6.33 4.3.6.52 4.3.6.19 4.3.6.58 4.3.6.42

9. UNIX for Beginners Questions & Answers

Sort Command

Hi All, I have used sort -k1 -n data.txt > output.txt command on a large text data file with over 1,000,000 rows. The command managed to sort the data but the code did not read data according to sequence of occurrence. Given below are the first five lines of the data I need to sort; 1 1...

LEARN ABOUT XFREE86

getdate

GETDATE(1)                                                         User Commands                                                        GETDATE(1)

NAME

       getdate - AME

SYNOPSIS

       [-dv][-n dec][-f format] [ra dec sys] itype2otype [date and/or time]

DESCRIPTION

       Convert date and time between various formats

              [-dv][-n dec][-f format] itype2otype @file

              itype: nfd=ISOFITS fd=FITS, dt=yyyy.mmdd, hr=hh:mm:ss, deg=dd:mm:ss

              jd=Julian  Date,  mjd=Modified Julian Date hjd=Heliocentric Julian Date, mhjd=Modified HJD ep=epoch, epj=Julian epoch, epb=Besselian
              epoch lt=local time, ut=UT, ts=seconds since 1950-01-01 now=current time, ang=fractional degrees

              otype: fd=FITS, dt=yyyy.mmdd, jd=Julian Date, mjd=Modified Julian Date

              hjd=Heliocentric Julian Date, mhjd=Modified HJD  hr=hh:mm:ss,  deg=dd:mm:ss,  ang=fractional  degrees  ep=epoch,  epj=Julian  epoch,
              epb=Besselian epoch ts=seconds since 1950-01-01, tsu=Unix sec, tsi=IRAF sec gst=Greenwich Sidereal Time, lst=Local Sidereal Time

              @file: First one or two columns are in itype format ra dec sys:  Need for Heliocentric conversions

       -a: Append date to input file, if there is one

       -d: Print date without time

       -e: Print output as ET/TDT/TT converting from UT

       -f: Format for output number (C printf)

       -h hours: Longitude in hours, west positive

       -l degrees: Longitude in degrees, west positive

       -n: Number of decimal places in sec, epoch, JD

       -t: Print time without date

       -v: Verbose

getdate 3.8.4                                                        June 2012                                                          GETDATE(1)