Sort comand for Date Post: 302377205

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Sort comand for Date Post 302377205 by jsmithstl on Thursday 3rd of December 2009 11:00:18 AM

12-03-2009

Registered User

Someone might know a way to accomplish this with sed or awk. Here's what I found with the sort command. Kinda strange behavior though.

Code:

data:
cat f1.dat
2009/07/23 11:48:44|alpha
2009/07/23 11:48:44|gamme
2009/12/23 11:48:44|beta
2009/11/23 11:48:44|test
2009/05/23 11:48:44|test
2009/07/23 11:48:44|data
1999/07/23 11:48:41|bbbb
1999/07/23 11:48:41|aaaa
2009/07/23 11:48:44|hello
2009/07/23 11:48:44|cat
2009/07/23 11:48:41|zulu
2008/07/23 11:48:41|zulu
2008/07/23 11:48:41|cccc

You'd think this would work but it doesn't

sort cmd:  sort -n -s -t '|' -k 1 f1.dat

output:
1999/07/23 11:48:41|bbbb
1999/07/23 11:48:41|aaaa
2008/07/23 11:48:41|zulu
2008/07/23 11:48:41|cccc
2009/07/23 11:48:44|alpha
2009/07/23 11:48:44|gamme
2009/12/23 11:48:44|beta
2009/11/23 11:48:44|test
2009/05/23 11:48:44|test
2009/07/23 11:48:44|data
2009/07/23 11:48:44|hello
2009/07/23 11:48:44|cat
2009/07/23 11:48:41|zulu

Ugly but it works
sort cmd:  sort -n      \
                -s      \
                -t      \
                -k 1.1  \
                -k 1.2  \
                -k 1.3  \
                -k 1.4  \
                -k 1.5  \
                -k 1.6  \
                -k 1.7  \
                -k 1.9  \
                -k 1.10 \
                -k 1.11 \
                -k 1.12 \
                -k 1.13 \
                -k 1.14 \
                -k 1.15 \
                -k 1.16 \
                -k 1.17 \
                -k 1.18 \
                -k 1.19 \
              f1.dat

output:
1999/07/23 11:48:41|bbbb
1999/07/23 11:48:41|aaaa
2008/07/23 11:48:41|zulu
2008/07/23 11:48:41|cccc
2009/05/23 11:48:44|test
2009/07/23 11:48:41|zulu
2009/07/23 11:48:44|alpha
2009/07/23 11:48:44|gamme
2009/07/23 11:48:44|data
2009/07/23 11:48:44|hello
2009/07/23 11:48:44|cat
2009/11/23 11:48:44|test
2009/12/23 11:48:44|beta

If we remove the \'s and :'s from the file:

data:
cat f2.dat
20090723114844|alpha
20090723114844|gamme
20091223114844|beta
20091123114844|test
20090523114844|test
20090723114844|data
19990723114841|bbbb
19990723114841|aaaa
20090723114844|hello
20090723114844|cat
20090723114841|zulu
20080723114841|zulu
20080723114841|cccc

this works:
sort cmd:  sort -n -s -t '|' -k 1 f2.dat

output:
19990723114841|bbbb
19990723114841|aaaa
20080723114841|zulu
20080723114841|cccc
20090523114844|test
20090723114841|zulu
20090723114844|alpha
20090723114844|gamme
20090723114844|data
20090723114844|hello
20090723114844|cat
20091123114844|test
20091223114844|beta

jsmithstl

View Public Profile for jsmithstl

Find all posts by jsmithstl

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort by Date

I'm looking to edit a file which contains various data including date.(ddmmyyyy) I want to sort by date and then count the number of different dates found Any ideas how to acheive this Thanks in advance.

2. Shell Programming and Scripting

Sort By Date and Time

Hi , I would like to list or sort by date and time (the files are named in day and time format) where the latest file will be placed at the bottom and the earliest file be placed at the top. Can anybody help me? My files are named in the following manner. EG: abc_071128_144121_data "...

3. Linux

sort files by date

Hi All, Sorry to throw this frequent question but I lost my notes on it. How do you list the files by date? I'm on red hat. Thanks in advance, itik

4. Shell Programming and Scripting

how to sort by the date

Hello World~ Please Help Me(BASH) input: dde,2007.8.25,891 dde,2007.8.23,356 dfe,2007.10.12,341 cba,2005.12.5,342 I wanna know how to sort by the date(2005.12.5) output: cba,2005.12.5,342 dde,2007.8.23,356 dde,2007.8.25,891 dfe,2007.10.12,341 Thanks in advance

5. Shell Programming and Scripting

sort date issue

Hi Everyone, # cat b Sat 12 Sep 2009 10:31:49 PM MYT;a;a;a;Sun 13 Sep 2009 11:32:49 AM MYT; Sat 13 Sep 2009 10:31:49 PM MYT;a;a;a;Mon 14 Sep 2009 10:31:49 PM MYT; Sat 14 Sep 2009 10:31:49 PM MYT;a;a;a;Sun 13 Sep 2009 10:31:49 PM MYT; # sort -t';' -k5 b Sat 13 Sep 2009 10:31:49 PM...

6. UNIX for Dummies Questions & Answers

how to combine du -h and sort by date

The problem: I have a task to give a my boss: 1. the files and directory sizes in human readable form: du -h 2. He also wants me to give him the date stamp on the files and directories. something like ls -R or sort by date Does anyone have a script that can do this efficiently (I am...

7. Shell Programming and Scripting

sort the date

Hi All, Please help me to sort the date field which is in the format 2012-02-03 16:09:37.388... Platform: Red Hat linux Thanks in advance

8. Shell Programming and Scripting

How to Sort by Date and Time?

Hi, The input file is as follows, 22.06.2012 17:58:38 CPUser: xxxxxxx, billedAfterStatus: Active 13.07.2012 08:46:15 CPUser: xxxxxxx, billedAfterStatus: Active 20.07.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active 20.03.2012 08:56:24 CPUser: xxxxxxx, billedAfterStatus: Active...

9. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

Hi Experts, I have a filelist collected from another server , now want to sort the output using date/time stamp filed. - Filed 6, 7,8 are showing the date/time/stamp. Here is the input: #---------------------------------------------------------------------- -rw------- 1 root ...

10. Shell Programming and Scripting

Sort by name and date

nawk '$1=="Date" {d=$(NF-2);next} $1=="Queue" {q=$NF;next} $1=="Forms"{print q, $NF, d}' OFS='|' printfile.log I have this script working. Please let me know how to sort by Queue and then Date.

LEARN ABOUT REDHAT

ppmtosixel

ppmtosixel(1)						      General Commands Manual						     ppmtosixel(1)

NAME

       ppmtosixel - convert a portable pixmap into DEC sixel format

SYNOPSIS

       ppmtosixel [-raw] [-margin] [ppmfile]

DESCRIPTION

       Reads  a  portable  pixmap  as input.  Produces sixel commands (SIX) as output.	The output is formatted for color printing, e.g. for a DEC
       LJ250 color inkjet printer.

       If RGB values from the PPM file do not have maxval=100, the RGB values are rescaled.  A printer control header and a color assignment table
       begin the SIX file.  Image data is written in a compressed format by default.  A printer control footer ends the image file.

OPTIONS

       -raw   If  specified,  each  pixel  will  be explicitly described in the image file.  If -raw is not specified, output will default to com-
	      pressed format in which identical adjacent pixels are replaced by "repeat pixel" commands.  A raw file is often an order	of  magni-
	      tude larger than a compressed file and prints much slower.

       -margin
	      If  -margin  is not specified, the image will be start at the left margin (of the window, paper, or whatever).  If -margin is speci-
	      fied, a 1.5 inch left margin will offset the image.

PRINTING

       Generally, sixel files must reach the printer unfiltered.  Use the lpr -x option or cat filename > /dev/tty0?.

BUGS

       Upon rescaling, truncation of the least significant bits of RGB values may result in poor color conversion.  If the original PPM maxval was
       greater	than  100,  rescaling  also reduces the image depth.  While the actual RGB values from the ppm file are more or less retained, the
       color palette of the LJ250 may not match the colors on your screen.  This seems to be a printer limitation.

SEE ALSO

       ppm(5)

AUTHOR

       Copyright (C) 1991 by Rick Vinci.

								   26 April 1991						     ppmtosixel(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort by Date

Discussion started by: Mudshark

2. Shell Programming and Scripting

Sort By Date and Time

Discussion started by: Raynon

3. Linux

sort files by date

Discussion started by: itik

4. Shell Programming and Scripting

how to sort by the date

Discussion started by: lifegeek