Sponsored Content
Top Forums Shell Programming and Scripting Sort help: How to sort collected 'file list' by date stamp : Post 302787537 by ahamed101 on Friday 29th of March 2013 07:51:28 PM
Old 03-29-2013
Try this

Code:
awk 'BEGIN{mon["Jan"]=1;mon["Feb"]=2;mon["Mar"]=3;mon["Apr"]=4;mon["May"]=5;mon["Jun"]=6;mon["Jul"]=7;mon["Aug"]=8;mon["Sep"]=9;mon["Oct"]=10;mon["Nov"]=11;mon["Dec"]=12;} 
{ split($8, hhmm, /:/); format="2012 "mon[$6]" "$7" "hhmm[1]" "hhmm[2]" 00 00"; t=mktime(format); a[t]=$0; b[++j]=t; } 
END{n=asort(b); for(i=1;i<=n;i++){print a[b[i]]}}' input_file

--ahamed

---------- Post updated at 04:51 PM ---------- Previous update was at 04:49 PM ----------

Updated the code : there was a syntax error.

--ahamed
This User Gave Thanks to ahamed101 For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sort a file by date using perl

Hello, do any body help me to sort a file by date using perl? thanks in advance Esham (4 Replies)
Discussion started by: esham
4 Replies

2. AIX

loop through the directory for files and sort by date and process the first file

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)
Discussion started by: dsdev_123
1 Replies

3. Shell Programming and Scripting

how to sort paragraphs by date within a file

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)
Discussion started by: nabmufti
1 Replies

4. Shell Programming and Scripting

How to sort a field in a file having date values

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

5. Shell Programming and Scripting

Sort content of text file based on date?

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)
Discussion started by: KidCactus
19 Replies

6. Shell Programming and Scripting

shell script to sort entries in a file by date and time

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)
Discussion started by: ajiwww
10 Replies

7. UNIX for Advanced & Expert Users

Script to sort the files and append the extension .sort to the sorted version of the file

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)
Discussion started by: pankaj80
3 Replies

8. Shell Programming and Scripting

Is it Possible to sort a list of hexadecimal numbers using "sort" command?

Hello Everybody :) !!!. i have question in mind, is it possible to sort a list of hexadecimal numbers using "sort" command? (9 Replies)
Discussion started by: Kesavan
9 Replies

9. UNIX for Dummies Questions & Answers

List directories with given string, sort by creation date

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)
Discussion started by: Siva SQL
3 Replies

10. Shell Programming and Scripting

Help with sort list of file based on similarity

Input file (long list of input file): s_1_1_AABCD.txt s_1_1_ABADA.txt s_1_1_DSCBA.txt s_1_1_DSCCA.txt s_1_1_EATTG.txt s_1_1_FADSD.txt s_1_1_TGACC.txt s_1_1_TTAGG.txt s_1_2_AABCD.txt s_1_2_ABADA.txt s_1_2_DSCBA.txt s_1_2_DSCCA.txt s_1_2_EATTG.txt s_1_2_FADSD.txt ... (1 Reply)
Discussion started by: perl_beginner
1 Replies
monshow(1)							      monshow								monshow(1)

NAME
monshow - show operational status of mon server. SYNOPSIS
monshow [--help] [--showall] [--full] [--disabled] [--detail group,service] [--view name] [--auth] [--login user] [--old] [--server host- name] [--port portnum] [--prot protocol] [--rcfile file] DESCRIPTION
monshow show the operational status of the mon server. Both command-line and CGI interfaces are available. OPTIONS
--help show help --showall Do not read configuration file, and show operational status of all groups and services. --full Instead of showing only failed services, show all services no matter the state. --detail group,service Display detailed information for group and service. This includes description, detailed output of the monitor, dependency informa- tion, and more. When invoked via CGI, append "detail=group,service" to get detail for a service. --view name Display a pre-configured view. When invoked via CGI, supply the arguments "view=name" in the URL, or by using this technique: "http://monhost/monshow.cgi/name". For security reasons, leading forward slashes and imbedded ".."s are removed from the view name. --auth Authenticate client to the mon server. --disabled Show disabled groups, services, and hosts. The default is to not show anything which is disabled, but this may be overridden by the config file. --server hostname Connect to the mon server on host hostname. hostname can be either the name of a host or an IP address. If this name is not sup- plied by this argument, then the environment variable MONHOST is used, if it exists. Otherwise, monshow will fail. --login username When authenticating, use username. --port portnum Connect to the server on portnum. --prot protocol Sets the protocol to protocol. The protocol must match the format "1.2.3". If unset, the default supplied by the Mon::Client module is used. Do not use this parameter unless you really know what you are doing. --old Use the old 0.37 protocol and port number (32777). --rcfile file Use configuration file file instead of ~/.monshowrc. CGI INVOCATION
If monshow is invoked with the "REQUEST_METHOD" environment variable set, then CGI invocation is assumed. In that case, monshow gathers variables and commands submitted via the POST method and QUERY_STRING. Command-line options are ignored for security reasons. All reports which are produced via the web interface have a text mode equivalent. VIEWS
A view is a pre-defined configuration supplied to monshow. Views can be used to generate different reports of the status of certain ser- vices for different audiences. They are especially useful if you are monitoring hundreds of things with mon, and you need to see only a subset of the overall operational status. For example, the web server admins can see a report which has only the web server statuses, and the file server admins can have their own report which shows only the servers. Users can customize their own views by editing their own configurations. Views are stored as files in a system-wide directory, typically /etc/mon/monshow, where each file specifies one view. If this path is not suitable for any reason, it can be changed by modifying the $VIEWPATH variable in the monshow script. When invoking monshow from the command line, the view to display is specified by the --view=name argument. In the case of CGI invocation, views can be specified by appending either ?view=name or /name to the URL. For example, the following are equivalent: http://monhost/monshow.cgi?view=test http://monhost/monshow.cgi/test If a view is not specified, then a default configuration will be loaded from $HOME/.monshowrc (command-line invocation) or cgi-path/.mon- showrc (CGI invocation). VIEW CONFIGURATION FILE
The view file contains a list of which services to display, how to display them, and a number of other parameters. Blank lines and lines beginning with a # (pound) are ignored. watch group Include the status of all the services for "group". service group service Include the status of the service specified by group and service. If no watch or service configuration lines are present, then the status of all groups and services are displayed. set show-disabled This has the same effect as using the --disabled option. set host hostname Query the mon server hostname. set port number The TCP port which the mon server is listening on. set prot protocol Set the protocol. This probably should not be used unless you really know what you're doing. set full Show everything disabled, all failures, all successes, and all untested services. set bg color Background color for the CGI report. The value of this parameter should resemble "d5d5d5" (without the quotes). set bg-ok color Background color for services which are in an "ok" state. set bg-fail color Background color for services which are failing. set bg-untested color Background color for services which have yet to be tested. set refresh seconds For CGI output, set the frequency that the report reloads. The default is to not reload. summary-len len For CGI output, set the maximum length of the summary output to display. Summary text which exceeds len will be truncated and replaced with ellipses. link group service URL For the CGI report, make a link to URL at the bottom of the detail report for group/service for more information. link-text group service Insert all HTML up until a line beginning with "END" after the link specified with the link setting. set html-header Lines after this statement, continuing up until a line beginning with the word "END" will be displayed after the "</head>" tag in the CGI output. Use this to display custom headers, including images and other fancy things. ENVIRONMENT VARIABLES
MONHOST The hostname of the server which runs the mon process. SEE ALSO
mon(8) BUGS
Report bugs to the email address below. AUTHOR
Jim Trocki <trockij@arctic.org> Linux $Date: 2005/04/17 07:42:27 $ monshow(1)
All times are GMT -4. The time now is 03:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy