Sponsored Content
Full Discussion: how to sort by the date
Top Forums Shell Programming and Scripting how to sort by the date Post 302265271 by Christoph Spohr on Saturday 6th of December 2008 08:40:06 AM
Old 12-06-2008
Hi,

or in a one-liner with tr and sort. First use tr to convert als "," to ".",
then sort numerically with "." als field delimeter fields two and three.

Code:
tr "," "\." < file | sort -n -t"." -k2,2 -k3,3

HTH Chris
 

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 Replies)
Discussion started by: Mudshark
2 Replies

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 "... (21 Replies)
Discussion started by: Raynon
21 Replies

3. UNIX for Dummies Questions & Answers

sort by date and concatenate first three

Hi: I am trying to create some script that sorts the files in a subdirectory by date and concatenates the thre most recently created files. SAy, file1 date1 file2 date2 file3 date3 file4 date4 file5 date5 file6 date6 i only want to concatenate the first three which are the most... (4 Replies)
Discussion started by: jlarios
4 Replies

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

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

6. UNIX for Dummies Questions & Answers

Sort comand for Date

Hi All, I have two questions for sorting based on date. Sample input: 2009/07/23 11:48:44|alpha 2009/07/23 11:48:44|gamme 2009/07/23 11:48:44|beta 2009/07/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 Output: 2009/07/23... (3 Replies)
Discussion started by: quintet
3 Replies

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

8. Shell Programming and Scripting

Sort Date YYYYDDD

Hello, I am still in trouble to sort log file in order by date as (YYYYDDD). INFO : YYYY = Year DDD = Day in the year 001 for 1st January Here is Input New File: 95106 Oct 21 TAG__SC___2000229_0.TAB New File: 95040 Mar 29 TAG__KSM__2012023_0.TAB New File: 95106 Oct 21... (11 Replies)
Discussion started by: Aswex
11 Replies

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

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. (4 Replies)
Discussion started by: Daniel Gate
4 Replies
DATEFUDGE(1)							      Debian							      DATEFUDGE(1)

NAME
datefudge - pretend the system time is different SYNOPSIS
datefudge [-s|--static] at_date program [arguments ...] DESCRIPTION
datefudge is a small utility that pretends that the system time is different by pre-loading a small library which modifies the time(2), gettimeofday(2) and clock_gettime(2) system calls. OPTIONS
--static, -s set date as a `static' one. The above mentioned system calls will always return the date passed as a parameter of the program regardless of time passing. See EXAMPLES below. --help, -h print short usage information and exit. --version, -v print version information and exit. EXAMPLES
Basic example: $ datefudge "2007-04-01 10:23" date -R Sun, 01 Apr 2007 10:23:00 +0200 Non-static vs. static example: $ datefudge "2007-04-01 10:23" sh -c "sleep 3; date -R" Sun, 01 Apr 2007 10:23:03 +0200 $ datefudge --static "2007-04-01 10:23" sh -c "sleep 3; date -R" Sun, 01 Apr 2007 10:23:00 +0200 AUTHOR
Written by Matthias Urlichs <smurf@noris.de>. Modified by Robert Luberda <robert@debian.org>. BUGS
There is no attempt to make this change undetectable by the program. In particular, file modification times are not modified. COPYRIGHT
Copyright (C) 2003 by Matthias Urlichs. Copyright (C) 2008-2011 by Robert Luberda. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute copies of datefudge under the terms of the GNU General Public License. For more information about these matters, see the file named COPYING. SEE ALSO
ld.so(1), time(2), gettimeofday(2), clock_gettime(2) datefudge 1.17 June 23th, 2011 DATEFUDGE(1)
All times are GMT -4. The time now is 06:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy