Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Sort field by date mm/dd/yyyy Post 302399711 by csierra on Monday 1st of March 2010 09:50:51 AM
Old 03-01-2010
Sort field by date mm/dd/yyyy

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"
Code:
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
12/23/2009,1.0393
12/18/2009,1.0427
12/21/2009,1.0459
12/17/2009,1.0467
12/22/2009,1.0482

I really appreciate it youe help and support

Carlos

Last edited by radoulov; 03-01-2010 at 10:53 AM.. Reason: Please use code tags!
 

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
VITE(1) 							 ViTE Manual Pages							   VITE(1)

	 ..___________..._
    __vXXX=========onn=XX=X=s_..
_a=X=============v:|||||i:lvvn=Xn_,
 "!XX===========v||||||||||||iiiv=Xn_
    -"!XX======v||||||||||||iii:::vn=Xs
	 ""!!!Zl|||||||||||iii::lIlvvnXX,.
	      Jl||||||||||i:vvvvlIvvvvv=Zc
	     _e|||||||||ia}"""""!=anvnvnnXno=========aa_.
	     ]l||||||||v}'	   "Xnnnnnn=o=====XXXX=adZ=__
	     =||||||||n(	   .3nnnon=======X=Xs..___X|%!n_,
	    )1||||||i;^ 	    3=noo=======X=XXXZ1v|i|||||iIs,
	    X||||||a!		    3=n========X=X=X=Ii||||||||||iIs,
	  .Jl|||va!		   .==o=o=====X=XXX=li|||||||||||||i3..
	  )na:!"`		    =========X=XX=1:|||||||||||||||||)a
	  ..			   .========X=XXIIi||||||||||||||||||v}
				    X=====X=X=1l|i|||||||||||||<a>}""^
				   .X===X==1Ii||||||||||||<a>""`:
				    +X=nI:i|||:llv_asl}"""`
				     -ni||<c"^.
				      -1%<e.
					!3`

NAME
vite - a visual trace explorer SYNOPSIS
vite vite -h vite [-f|-a] file_path [-e export_path] [-t [time_init]:[time_end]] DESCRIPTION
ViTE is a visual trace explorer. It is a useful tool for profiling and debugging parallel programs (multi-process or multi-core). ViTE reads program execution trace data from file (currently in Paje trace format) and display it in a graphical interface. Program execu- tion data could be a state (drawn as a colored rectangle - color depends of the kind of state), an event (drawn as a green disc) or a com- munication between two processes (drawn as a white arrow). OPTIONS
ViTE accepts the following options: -h Display help. -f file_path Open the file_path file. -a file_path Open the file_path file and display it entirely. -e export_path Export the opened trace file (with -f or -a option) to the export_path file in SVG format. -t [time_init]:[time_end] Just parse trace from time_init to time_end. If time_init is missed, trace will be parsed from the minimum time to time_end. If time_end is missed, trace will be parsed from time_init to the maximum time. AUTHORS
ViTE was created by a group of french engineering school students for the INRIA research center. REPORTING BUGS
Report bugs to ViTE developers <vite-developpeurs@lists.gforge.inria.fr>. COPYRIGHT
ViTE was released under the CeCILL-A licence. The content can be found here: http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt. Copyright (C) 2009 Kevin COULOMB Copyright (C) 2009 Johnny JAZEIX Copyright (C) 2009 Olivier LAGRASSE Copyright (C) 2009 Jule MARCOUEILLE Copyright (C) 2009 Pascal NOISETTE Copyright (C) 2009 Arthur REDONDY Copyright (C) 2009 Clement VUCHENER This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Version 1.2 April 2009 VITE(1)
All times are GMT -4. The time now is 01:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy