Sponsored Content
Full Discussion: Help with sort command
Top Forums Shell Programming and Scripting Help with sort command Post 302589076 by Yoda on Tuesday 10th of January 2012 06:12:14 PM
Old 01-10-2012
Help with sort command

I have a file with the following content:-

181268525,0640613864,B,113,22-dec-2011 14:12:08,
181268525,0640613864,C,113,25-dec-2011 14:18:50,
181268525,0640613864,L,113,26-dec-2011 14:07:46,
181268525,0640613864,X,113,01-jan-2012 16:57:45,
181268525,0640613864,X,113,04-jan-2012 14:13:27,
181268525,0640613864,X,113,29-dec-2011 14:04:12,
181268525,0640613864,Y,113,02-jan-2012 13:58:08,
181268525,0640613864,Y,113,05-jan-2012 14:14:18,
181268525,0640613864,Y,113,08-jan-2012 14:11:43,

I am running the sort command on this file to sort by the date, but somehow I am not getting the expected results:-

cat test | sort -t',' -k 5.10,5.14 -k 5.15,5.18M -k 5.19,5.20
181268525,0640613864,B,113,22-dec-2011 14:12:08,
181268525,0640613864,X,113,29-dec-2011 14:04:12,
181268525,0640613864,L,113,26-dec-2011 14:07:46,
181268525,0640613864,C,113,25-dec-2011 14:18:50,
181268525,0640613864,Y,113,02-jan-2012 13:58:08,
181268525,0640613864,Y,113,05-jan-2012 14:14:18,
181268525,0640613864,X,113,04-jan-2012 14:13:27,
181268525,0640613864,Y,113,08-jan-2012 14:11:43,
181268525,0640613864,X,113,01-jan-2012 16:57:45,

01-jan-2012 is appearing after 08-jan-2012. Please assist.

Last edited by Yoda; 01-10-2012 at 07:29 PM..
 

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... (1 Reply)
Discussion started by: rjjenkin
1 Replies

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........ (2 Replies)
Discussion started by: xli
2 Replies

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... (8 Replies)
Discussion started by: Indalecio
8 Replies

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 :... (3 Replies)
Discussion started by: manmeet
3 Replies

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... (7 Replies)
Discussion started by: daniel.gbaena
7 Replies

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. (1 Reply)
Discussion started by: RiderOnsky
1 Replies

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? (9 Replies)
Discussion started by: Kesavan
9 Replies

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 (5 Replies)
Discussion started by: dnam9917
5 Replies

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... (2 Replies)
Discussion started by: Theo Score
2 Replies
DCSTATS(1)						DICOM PS3 - DICOM image statistics						DCSTATS(1)

NAME
dcstats - ACR/NEMA DICOM PS3 ... DICOM PS3 - DICOM image statistics SYNOPSIS
dcstats [ -v|verbose ] [ -filename ] DESCRIPTION
dcstats reads the named dicom or acr-nema input file and describes the statistics of the image pixel data. The primary intent is to deter- mine if the pixel representation is unsigned or signed (regardless of what other attributes may specify). The description and verbose output go to standard error. The basic input switches are described in dcintro(1). Options specific to this program are: -v|verbose Display byte offset from file start and message start, in hexadecimal, and dump contents while reading and once read. -filename Show the name of the file supplied in the arguments; a hyphen will be reported if no filename was supplied. -filename Show the name of the file supplied in the arguments; a hyphen will be reported if no filename was supplied. ENVIRONMENT
EXAMPLES
% dcstats expmeta.dc3 Signed minimum value = 0x0 (0 dec) Signed maximum value = 0x6e9 (1769 dec) Unsigned minimum value = 0x0 (0 dec) Unsigned maximum value = 0x6e9 (1769 dec) Signed range = 0x6e9 (1769 dec) Unsigned range = 0x6e9 (1769 dec) Signed mean = 0x158 (344 dec) (19.446%) Unsigned mean = 0x158 (344 dec) (19.446%) Bits Stored = 16 Significant unsigned bits = 11 % dcstats impnone.dc3 Signed minimum value = 0xfa24 (64036 dec) Signed maximum value = 0x638 (1592 dec) Unsigned minimum value = 0x0 (0 dec) Unsigned maximum value = 0xffff (65535 dec) Signed range = 0xc14 (3092 dec) Unsigned range = 0xffff (65535 dec) Signed mean = 0xfec2 (65218 dec) (38.2277%) Unsigned mean = 0x1cdd (7389 dec) (11.2749%) Bits Stored = 16 Significant positive bits = 11 Significant negative bits = 11 Offset to make unsigned in hex is = 0x5dc Offset to make unsigned in dec is = 1500 FILES
SEE ALSO
dchist(1), dcintro(1) AUTHOR
Copyright (C) 1993-2010. David A. Clunie DBA PixelMed Publishing. All rights reserved. BUGS
DICOM PS3 6 March 2007 DCSTATS(1)
All times are GMT -4. The time now is 08:28 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy