04-18-2005
Quote:
Originally Posted by Mudshark
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.
I assume you have 'columns' of data one of which is 'date' in the format '
ddmmyyyy'.
Make a new first column in the format '
yyyymmdd' from your ofiginal record.
Sort by the first column - 'man sort' and then remove the first column: 'man cut'
Count 'uniq' records - 'man uniq'
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. UNIX for Dummies Questions & Answers
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
3. Linux
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
4. Shell Programming and Scripting
Hello World~
Please Help Me(BASH)
input:
dde,2007.8.25,891
dde,2007.8.23,356
dfe,2007.10.12,341
cba,2005.12.5,342
I wanna know how to sort by the date(2005.12.5)
output:
cba,2005.12.5,342
dde,2007.8.23,356
dde,2007.8.25,891
dfe,2007.10.12,341
Thanks in advance (3 Replies)
Discussion started by: lifegeek
3 Replies
5. Shell Programming and Scripting
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
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
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
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
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
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
LEARN ABOUT DEBIAN
date::parse
Date::Parse(3pm) User Contributed Perl Documentation Date::Parse(3pm)
NAME
Date::Parse - Parse date strings into time values
SYNOPSIS
use Date::Parse;
$time = str2time($date);
($ss,$mm,$hh,$day,$month,$year,$zone) = strptime($date);
DESCRIPTION
"Date::Parse" provides two routines for parsing date strings into time values.
str2time(DATE [, ZONE])
"str2time" parses "DATE" and returns a unix time value, or undef upon failure. "ZONE", if given, specifies the timezone to assume when
parsing if the date string does not specify a timezone.
strptime(DATE [, ZONE])
"strptime" takes the same arguments as str2time but returns an array of values "($ss,$mm,$hh,$day,$month,$year,$zone)". Elements are
only defined if they could be extracted from the date string. The $zone element is the timezone offset in seconds from GMT. An empty
array is returned upon failure.
MULTI-LANGUAGE SUPPORT
Date::Parse is capable of parsing dates in several languages, these include English, French, German and Italian.
$lang = Date::Language->new('German');
$lang->str2time("25 Jun 1996 21:09:55 +0100");
EXAMPLE DATES
Below is a sample list of dates that are known to be parsable with Date::Parse
1995:01:24T09:08:17.1823213 ISO-8601
1995-01-24T09:08:17.1823213
Wed, 16 Jun 94 07:29:35 CST Comma and day name are optional
Thu, 13 Oct 94 10:13:13 -0700
Wed, 9 Nov 1994 09:50:32 -0500 (EST) Text in ()'s will be ignored.
21 dec 17:05 Will be parsed in the current time zone
21-dec 17:05
21/dec 17:05
21/dec/93 17:05
1999 10:02:18 "GMT"
16 Nov 94 22:28:20 PST
LIMITATION
Date::Parse uses Time::Local internally, so is limited to only parsing dates which result in valid values for Time::Local::timelocal. This
generally means dates between 1901-12-17 00:00:00 GMT and 2038-01-16 23:59:59 GMT
BUGS
When both the month and the date are specified in the date as numbers they are always parsed assuming that the month number comes before
the date. This is the usual format used in American dates.
The reason why it is like this and not dynamic is that it must be deterministic. Several people have suggested using the current locale,
but this will not work as the date being parsed may not be in the format of the current locale.
My plans to address this, which will be in a future release, is to allow the programmer to state what order they want these values parsed
in.
AUTHOR
Graham Barr <gbarr@pobox.com>
COPYRIGHT
Copyright (c) 1995-2009 Graham Barr. This program is free software; you can redistribute it and/or modify it under the same terms as Perl
itself.
perl v5.10.1 2010-01-14 Date::Parse(3pm)