This will just use the "/" as a separator .. what i am trying to figure out is first sort the 1st column so lets say all 1234 together then within those, the date should be sorted.
hello,
i have a table contain many columns delimited by blank.
i want to sort this table by the 2 columns and 3 one and i want to keep the first line inchanged?
how can i do using the sort command?
thanks
table like :
field1 field2 field3 field4
x y z b
t h r n
.. (4 Replies)
Hi All,
I am having a pipe delimited file .In this file the 3rd column is having date values.I need to get the min date and max date from that file.
I have used
cut -d '|' test.dat -f 3|sort -u
But it is not sorting the date .How to sort the date column using unix commands
Thanks ... (4 Replies)
:cool:
Hi all,
I have a pecular issue in sorting these files in Solaris environment.
All the below files are modified on November 4th, but I want to sort these files as per date column (eg: 01May07_1623 = ddmmmyy_hhmm)
Nov 4 18:27 SONYELEC00.GI22973.01May07_1623.gpg
Nov 4 18:27... (4 Replies)
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... (1 Reply)
Hello Group,
I would like to sort the below file by date (first year then month and day) and I used the following command but it does not work
sort -n -t"/" -k3 -k1 -k2
"sample original file"
12/28/2009,1.0353
12/31/2009,1.0357
12/30/2009,1.0364
12/29/2009,1.0366
12/24/2009,1.0386... (6 Replies)
Hi colleagues,
I have this output, i need sort for 7th and 8th columns, the column 7th is date mm/dd/yyyy format and column 8th is time hh:mm:ss.number
PRUEBA 1263 0007 1 0 7131292 03/25/2013 16:43:04.159976 PROCESS
PRUEBA1 666 0146 1 0 11600064 ... (1 Reply)
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 ... (3 Replies)
New to unix.
I need to sort the records of a file by a control number field. That field is in POS 16 through 28. How do I do that? There are no delimiters, or spaces to separate fields.
See example below. Each line is a record.
REC1CCYYMMDD0018888888888888ABCDE... (1 Reply)
I wanted to sort the below data on 4th field(comma seperator) based on month and date and time on AIX OS.
Input data:
3,AJ,30 Jul 06:30,30 Jul 06:30
5,AJ,30 Jul 06:30,30 Jul 06:49
10,AJ,30 Jul 06:30,02 Jan 05:41
4,AJ,30 Jul 06:30,30 Jul 06:36
2,AJ,30 Jul 06:30,28 Jul 06:45
9,AJ,30 Jul... (2 Replies)
Discussion started by: Amit Joshi
2 Replies
LEARN ABOUT DEBIAN
dcsort
DCSORT(1) DICOM PS3 - Make sorted list of images DCSORT(1)NAME
dcsort - ACR/NEMA DICOM PS3 ... DICOM PS3 - Make sorted list of images
SYNOPSIS
dcsort " inputfile1 [ inputfile2 ... ]" [ -v|verbose ] [ -vv|veryverbose ] [ -vvv|veryveryverbose ] [ -index ] [ -show ] [ -interval ] [
-tolerance mm ] [ -check ] [ -checkFoR ] [ -descending ] [ -sortby|k attributename ]
DESCRIPTION
dcsort reads the named dicom input files and sorts them by the specified sort key.
The sort key should be a single valued numeric attribute, with the exception of ImageOrientationPatient and ImagePositionPatient which are
handled as special cases.
There is no output by default unless the index or verbose options are specified.
OPTIONS
The output and errors go to standard error.
The basic input switches are described in dcintro(1). Options specific to this program are:
-index
Creates a first column of output that is the index in the sort order, starting from 0, and a second column that is the filename.
-show
Show the value of the sort key after the file name with the -index option
-interval
Show the interval between values of the sort key, or an error if not equal
-tolerance mm
The tolerance value in mm to use when comparing intervals between slices; defaults to +/- 0.01 mm if unspecified
-check
Check that all the images are from the same series.
-checkFoR
Check that all the images have the same Frame of Reference (UID).
-descending
Sort in descending, rather than the default ascending, order.
-sortby|k attributename
Specify attributename as the sort key.
ENVIRONMENT EXAMPLES
% dcsort -index -sortby SliceLocation ./1/[0-9]*
0 ./1/1
1 ./1/2
FILES SEE ALSO dcintro(1)AUTHOR
Copyright (C) 1993-2010. David A. Clunie DBA PixelMed Publishing. All rights reserved.
BUGS DICOM PS3 22 December 2006 DCSORT(1)