Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sort field by date mm/dd/yyyy
Top Forums UNIX for Dummies Questions & Answers Sort field by date mm/dd/yyyy Post 302399712 by anbu23 on Monday 1st of March 2010 09:54:05 AM
Old 03-01-2010
Code:
$ sort -n -t"/" -k3 -k1 -k2 file
12/17/2009,1.0467
12/18/2009,1.0427
12/21/2009,1.0459
12/22/2009,1.0482
12/23/2009,1.0393
12/24/2009,1.0386
12/28/2009,1.0353
12/29/2009,1.0366
12/30/2009,1.0364
12/31/2009,1.0357

What do you mean by not working? What is your expected output?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Change Date from dd-mmm-yyyy to mm/dd/yyyy

I want to change a date from format dd-mmm-yyyy to mm/dd/yyyy. Is there a way to do this with sed or do you have to write a case statement to convert JAN to 01? Thanks (9 Replies)
Discussion started by: stringzz
9 Replies

2. Shell Programming and Scripting

How to Sort files on date field

: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)
Discussion started by: shivaastrogun
4 Replies

3. Shell Programming and Scripting

Perl script to extract last date field (yyyy/mm/dd)

Hi Friends, I've a special requirement, even though I know how to implement this using shell scripting, current requirement is PERL, in which I'm not much familiar !!!. I've a record, which has around 200 fields, out of which I need to extract only one date value from the 97th field (this... (1 Reply)
Discussion started by: ganapati
1 Replies

4. Shell Programming and Scripting

converting the date field from dd/mm/yyyy to yyyy/mm/dd

How to convert the date field from dd/mm/yyyy to yyyy/mm/dd in unix my script will generate text file which have two fields one is date and another is name of the server for example this is sample date which I have to sort based on older to newer date the problem is when I found out sort will... (4 Replies)
Discussion started by: pareshan
4 Replies

5. Shell Programming and Scripting

Sort two columns in a field, one of them being a date

Hi, I have a set of columns in a csv file, my first row being an integer and 2nd being a date. I want to first sort it using the first column and then by the second. for e.g. i have , 1234,09/05/2009,hi 5678,01/01/2008,hi 1234,11/03/2006,hello 5678,28/07/2010,hello i tried this... (5 Replies)
Discussion started by: sweta_doshi
5 Replies

6. Shell Programming and Scripting

change date format from yyyy/mm/dd to dd/mm/yyyy

(Attention: Green PHP newbie !) I have an online inquiry form, delivering a date in the form yyyy/mm/dd to my feedback form. If the content passes several checks, the form sends an e-mail to me. All works fine. I just would like to receive the date in the form dd/mm/yyyy. I tried with some code,... (6 Replies)
Discussion started by: keyboarder
6 Replies

7. Shell Programming and Scripting

Converting date DD MM YYYY to DD MON YYYY

Hello, I am writing a script that parses different logs and produces one. In the source files, the date is in DD MM YYYY HH24:MI:SS format. In the output, it should be in DD MON YYY HH24:MI:SS (ie 25 Jan 2010 16:10:10) To extract the dates, I am using shell substrings, i.e.: read line ... (4 Replies)
Discussion started by: Adamm
4 Replies

8. Shell Programming and Scripting

Sorting Date Field with Sort -k :/

SOLVED : (17 Replies)
Discussion started by: Glitch100
17 Replies

9. UNIX for Dummies Questions & Answers

Epoch date to YYYY/MM/DD or MM/DD/YYYY

I've seen a lot of posts on this and have tried the following: echo 1257000000| perl -e '($d,$m,$y)=(localtime(time-86400));$m+=1;$y+=1900;printf "$y/$m/$d\n";' But I am unable to convert a past Epoch date into a format such as YYYY/MM/DD or MM/DD/YYYY. I am using bash and don't know... (4 Replies)
Discussion started by: newbie2010
4 Replies

10. AIX

Sort by date field in AIX

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

gdcmtar

gdcmtar(1)							       GDCM								gdcmtar(1)

NAME

       gdcmtar - Concatenate/Extract DICOM files.

SYNOPSIS

       gdcmtar [options] file-in file-out

DESCRIPTION

       The gdcmtar is a command line tool used to tar/untar multi-frames images (including SIEMENS MOSAIC file)

PARAMETERS

       file-in	 DICOM input filename

       file-out  DICOM output filename

options
   options
	    --enhance	 enhance (default)
	 -U --unenhance  unenhance
	 -M --mosaic	 Split SIEMENS Mosaic image into multiple frames.
	 -p --pattern	 Specify trailing file pattern.
	    --root-uid	      Root UID.

   general options
	 -h   --help
		print this help text and exit

	 -v   --version
		print version information and exit

	 -V   --verbose
		verbose mode (warning+error).

	 -W   --warning
		warning mode, print warning information

	 -E   --error
		error mode, print error information

	 -D   --debug
		debug mode, print debug information

   environment variable
	 GDCM_ROOT_UID Root UID

Typical usage
   SIEMENS Mosaic
       $ gdcminfo MR-sonata-3D-as-Tile.dcm

       MediaStorage is 1.2.840.10008.5.1.4.1.1.4 [MR Image Storage]
       TransferSyntax is 1.2.840.10008.1.2.1 [Explicit VR Little Endian]
       NumberOfDimensions: 2
       Dimensions: (384,384,1)
       ...

       $ gdcmtar --mosaic -i MR-sonata-3D-as-Tile.dcm -o mosaic --pattern %03d.dcm

       Will output:

       -rw-r--r--   1 mathieu mathieu 72882 2009-08-10 11:14 mosaic000.dcm
       -rw-r--r--   1 mathieu mathieu 72886 2009-08-10 11:14 mosaic001.dcm
       -rw-r--r--   1 mathieu mathieu 72886 2009-08-10 11:14 mosaic002.dcm
       -rw-r--r--   1 mathieu mathieu 72886 2009-08-10 11:14 mosaic003.dcm
       -rw-r--r--   1 mathieu mathieu 72886 2009-08-10 11:14 mosaic004.dcm
       -rw-r--r--   1 mathieu mathieu 72886 2009-08-10 11:14 mosaic005.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic006.dcm
       -rw-r--r--   1 mathieu mathieu 72882 2009-08-10 11:14 mosaic007.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic008.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic009.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic010.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic011.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic012.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic013.dcm
       -rw-r--r--   1 mathieu mathieu 72882 2009-08-10 11:14 mosaic014.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic015.dcm
       -rw-r--r--   1 mathieu mathieu 72882 2009-08-10 11:14 mosaic016.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic017.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic018.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic019.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic020.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic021.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic022.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic023.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic024.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic025.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic026.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic027.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic028.dcm
       -rw-r--r--   1 mathieu mathieu 72884 2009-08-10 11:14 mosaic029.dcm
       -rw-r--r--   1 mathieu mathieu 72882 2009-08-10 11:14 mosaic030.dcm

       $ gdcminfo mosaic000.dcm

       MediaStorage is 1.2.840.10008.5.1.4.1.1.4 [MR Image Storage]
       TransferSyntax is 1.2.840.10008.1.2.1 [Explicit VR Little Endian]
       NumberOfDimensions: 2
       Dimensions: (64,64,1)
       ...

SEE ALSO

       gdcmdump(1), gdcmraw(1), gdcminfo(1)

COPYRIGHT

       Copyright (c) 2006-2011 Mathieu Malaterre

Version 2.2.0							  Tue Feb 5 2013							gdcmtar(1)
All times are GMT -4. The time now is 02:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy