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:
Code:
#----------------------------------------------------------------------
-rw------- 1 root root 304182 Feb 12 18:09 /etc/cmconfig
-rw------- 1 root root 194056 Feb 12 17:41 /etc/cmconfig
-rw------- 1 root sys 125844 Oct 14 17:57 /etc/cmconfig
-rw------- 1 root sys 131010 Oct 14 17:57 /etc/cmconfig
-rw------- 1 root sys 131010 Oct 14 17:58 /etc/cmconfig
-rw------- 1 root dba 468206 Feb 12 17:54 /etc/cmconfig
-rw------- 1 root sys 327604 Jan 20 16:36 /etc/cmconfig
-rw------- 1 root sys 428022 Jan 28 16:19 /etc/cmconfig
-rw------- 1 root sys 554778 Jan 28 16:18 /etc/cmconfig
-rw------- 1 root sys 3122 Dec 6 16:09 /etc/cmconfig
-rw------- 1 root sys 955244 Dec 5 16:42 /etc/cmconfig
-rw------- 1 root root 294330 Aug 20 15:58 /etc/cmconfig
-rw------- 1 root users 295384 Aug 20 15:57 /etc/cmconfig
-rw------- 1 root users 295384 Aug 20 15:57 /etc/cmconfig
-rw------- 1 root root 177074 Jan 2 15:13 /etc/cmconfig
-rw------- 1 root root 53754 Feb 11 14:10 /etc/cmconfig
-rw------- 1 root sys 16512 Sep 26 14:11 /etc/cmconfig
-rw------- 1 root root 46532 Oct 22 13:45 /etc/cmconfig
-rw------- 1 root root 121888 Oct 22 13:47 /etc/cmconfig
-rw------- 1 root root 223998 Feb 9 11:31 /etc/cmconfig
-rw------- 1 root root 282906 Feb 10 10:17 /etc/cmconfig
-rw------- 1 root root 167484 Feb 10 10:24 /etc/cmconfig
-rw------- 1 root root 183984 Feb 9 10:43 /etc/cmconfig
-rw------- 1 root sys 18620 Sep 26 10:15 /etc/cmconfig
-rw------- 1 root sys 415972 Feb 4 09:30 /etc/cmconfig
-rw------- 1 root sys 3122 Dec 12 09:04 /etc/cmconfig
-rw------- 1 root users 424208 Dec 6 09:59 /etc/cmconfig
-rw------- 1 root users 423180 Dec 6 09:54 /etc/cmconfig
-rw------- 1 root users 423180 Dec 6 09:53 /etc/cmconfig
-rw------- 1 root sys 423180 Dec 6 09:52 /etc/cmconfig
-rw------- 1 root sys 20624 Feb 4 08:59 /etc/cmconfig
-rw------- 1 root root 71022 Nov 19 08:25 /etc/cmconfig
-rw------- 1 root sys 184478 Jan 29 08:20 /etc/cmconfig
-rw------- 1 root sys 431432 Oct 18 08:42 /etc/cmconfig
#----------------------------------------------------------------------
Want the output like this:
Code:
-rw------- 1 root root 177074 Jan 2 15:13 /etc/cmconfig
-rw------- 1 root sys 327604 Jan 20 16:36 /etc/cmconfig
-rw------- 1 root sys 428022 Jan 28 16:19 /etc/cmconfig
-rw------- 1 root sys 554778 Jan 28 16:18 /etc/cmconfig
-rw------- 1 root sys 184478 Jan 29 08:20 /etc/cmconfig
-rw------- 1 root sys 415972 Feb 4 09:30 /etc/cmconfig
-rw------- 1 root root 223998 Feb 9 11:31 /etc/cmconfig
hello
i have a requirement where i have a direcotry in which i get files in the format
STOCKS.20080114.dat
STOCKS.20080115.dat
STOCKS.20080117.dat
STOCKS.20080118.dat
i need to loop through the directory and sort by create date descending order and i need to process the first file.
... (1 Reply)
hi all
i want help in sortng date in paragraphs within file ,
i want to ask as if there any option to sort a certain pattern of file not the rest of file.i.e the data of file become sorted with respect to date
i have a log file as follows
!! *A0628/081 /08-01-10/13 H... (1 Reply)
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)
I now have a 230,000+ lines long text file formatted in segments like this:
Is there a way to sort this file to have everything in chronological order, based on the date and time in the text? In this example, I would like the result to be: (19 Replies)
Hello All,
Need a shell script to sort entries in a file by date and time. Below are the entries in the file, i need to sort it first by the date and then time
Note :- Date is in MM/DD/YY format and date comes as the 6th & time comes on 7th coloumns respectively.
150 pbnawldb001-b... (10 Replies)
Hello all -
I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
It is for HP-Unix B.11.31.
Requirement:
1. List the directories, which directories name has given particular string.
Example: Directories with name "Build"
2. On the output of 1. list the directories by creation date as sort order.
I tried with; find . -type d -name "Build*"
... (3 Replies)
clfmerge(1) logtools clfmerge(1)NAME
clfmerge - merge Common-Log Format web logs based on time-stamps
SYNOPSIS
clfmerge [--help | -h] [-b size] [-d] [file names]
DESCRIPTION
The clfmerge program is designed to avoid using sort to merge multiple web log files. Web logs for big sites consist of multiple files in
the >100M size range from a number of machines. For such files it is not practical to use a program such as gnusort to merge the files
because the data is not always entirely in order (so the merge option of gnusort doesn't work so well), but it is not in random order (so
doing a complete sort would be a waste). Also the date field that is being sorted on is not particularly easy to specify for gnusort (I
have seen it done but it was messy).
This program is designed to simply and quickly sort multiple large log files with no need for temporary storage space or overly large buf-
fers in memory (the memory footprint is generally only a few megs).
OVERVIEW
It will take a number (from 0 to n) of file-names on the command line, it will open them for reading and read CLF format web log data from
them all. Lines which don't appear to be in CLF format (NB they aren't parsed fully, only minimal parsing to determine the date is per-
formed) will be rejected and displayed on standard-error.
If zero files are specified then there will be no error, it will just silently output nothing, this is for scripts which use the find com-
mand to find log files and which can't be counted on to find any log files, it saves doing an extra check in your shell scripts.
If one file is specified then the data will be read into a 1000 line buffer and it will be removed from the buffer (and displayed on stan-
dard output) in date order. This is to handle the case of web servers which date entries on the connection time but write them to the log
at completion time and thus generate log files that aren't in order (Netscape web server does this - I haven't checked what other web
servers do).
If more than one file is specified then a line will be read from each file, the file that had the earliest time stamp will be read from
until it returns a time stamp later than one of the other files. Then the file with the earlier time stamp will be read. With multiple
files the buffer size is 1000 lines or 100 * the number of files (whichever is larger). When the buffer becomes full the first line will
be removed and displayed on standard output.
OPTIONS -b buffer-size
Specify the buffer-size to use, if 0 is specified then it means to disable the sliding-window sorting of the data which improves the
speed.
-d Set domain-name mangling to on. This means that if a line starts with as the name of the site that was requested then that would be
removed from the start of the line and the GET / would be changed to GET http://www.company.com/ which allows programs like Webal-
izer to produce good graphs for large hosting sites. Also it will make the domain name in lower case.
EXIT STATUS
0 No errors
1 Bad parameters
2 Can't open one of the specified files
3 Can't write to output
AUTHOR
This program, its manual page, and the Debian package were written by Russell Coker <russell@coker.com.au>.
SEE ALSO clfsplit(1),clfdomainsplit(1)Russell Coker <russell@coker.com.au> 0.06 clfmerge(1)