Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Regex match date and seconds format
Top Forums Shell Programming and Scripting Regex match date and seconds format Post 302949307 by Don Cragun on Thursday 9th of July 2015 03:34:08 AM
Old 07-09-2015
If you don't care about different dates being lumped together in the output, you could also try something like:
Code:
awk '{split($4,T,":");c[$1","T[3]":"T[4]]++}END{for(i in c)print c[i]","i}' access.log|sort -nr|head -n20

which would produce output something like:
Code:
62,192.168.10.6,14:40
41,192.168.10.32,58:57
21,192.168.10.32,47:57

with an obviously different input file than you were using (since you didn't provide a sample input file). Since you didn't provide any sample input, we have no idea why you would have 62 entries in your data with the same date and time stamps (nor, if there are different month, day, year, and hour entries in your data why you would only want to print minutes and seconds), so we're making wild guesses as to what might be important in your input file.
This User Gave Thanks to Don Cragun For This Post:
ashokvpp
 

10 More Discussions You Might Find Interesting

1. HP-UX

a simple way of converting a date in seconds to normal date

Hi all! I'm working on a HPUX system, and I was wondering if there is a simple way to convert a date from seconds (since 1970) to a normal date. Thanks (2 Replies)
Discussion started by: travian
2 Replies

2. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies

3. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies

4. Shell Programming and Scripting

Date conversion from Standard/given format to seconds/epoch

I am trying get time difference of two dates in secs. Initially I want to convert a standard date format to epoch for two dates and then subtract the two epoch dates. Example : date -d "2007-09-01 17:30:40" '+%s' But this gives me below error date: illegal option -- d Usage: date OS: AIX... (6 Replies)
Discussion started by: bpaac
6 Replies

5. UNIX for Dummies Questions & Answers

regex date format help

I need to write a regular expression for todays date in format 12/11/11? any help will be greatful thanks. (3 Replies)
Discussion started by: drew211
3 Replies

6. Shell Programming and Scripting

Date format in micro seconds

Can i get date format in micro seconds in unix example 2012-01-27- 12.22.04.568722 Any help is appreciable (2 Replies)
Discussion started by: srichunduru
2 Replies

7. UNIX for Dummies Questions & Answers

Rename all Files in a UNIX Directory from one date format to another date format

Hi Unix Gurus, I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Discussion started by: pchegoor
1 Replies

8. Shell Programming and Scripting

Sendmail K command regex: adding exclusion/negative lookahead to regex -a@MATCH

I'm trying to get some exclusions into our sendmail regular expression for the K command. The following configuration & regex works: LOCAL_CONFIG # Kcheckaddress regex -a@MATCH +<@+?\.++?\.(us|info|to|br|bid|cn|ru) LOCAL_RULESETS SLocal_check_mail # check address against various regex... (0 Replies)
Discussion started by: RobbieTheK
0 Replies

9. Shell Programming and Scripting

Pattern to match date in YYYY-MM-DD format on Linux machine

Hi Expert, Request your help. For date validation in csv file, i have written below code for linux machine I want the date to be in format 2017-05-11(YYYY-MM-DD), if not present in this format the error should be printed. Could you please help in finding the right pattern to match above date... (8 Replies)
Discussion started by: as7951
8 Replies

10. Shell Programming and Scripting

Converting time format as Integer to seconds

Hello, How can we convert date like format 20181004171050 in seconds ? I can able to convert till date but failing for HHMMSS. date -d "20181004" "+%s" output as 1538596800 . But when i add hhmmss it is failing date -d "20181004172000" "+%s" result Invalid date Kindly guide. Regards (16 Replies)
Discussion started by: sadique.manzar
16 Replies

LEARN ABOUT DEBIAN

oidentd_masq.conf

oidentd_masq.conf(5)						File Formats Manual					      oidentd_masq.conf(5)

NAME

       oidentd_masq.conf - oidentd IP masquerading/NAT configuration file.

DESCRIPTION

       If you are using IP masquerading or NAT, oidentd can optionally return a username for connections from other machines.  Support for this is
       specified by calling oidentd with the -m (or --masq) flag and by creating an /etc/oidentd_masq.conf file.

       oidentd can also forward requests for an IP masqueraded connection to the machine from which connection originates by way of the -f option.
       This  will  only  work if the host to which the connection is forwarded is running oidentd with the -P (proxy) flag, or if the host's ident
       daemon will return a valid reply regardless of the input supplied by and the address of the host requesting the info  (some  ident  daemons
       for windows do this, maybe others).

FORMAT

       <IP Address|Hostname>[/<Mask>] <Ident Response> <System Type>

       The  first  field  contains the IP address or the hostname of a machine that IP masquerades through the machine on which oidentd runs.  The
       mask parameter can be either a network mask or a mask in CIDR notation.	A mask of 24 is equivalent to  255.255.255.0,  a  mask	of  16	is
       equivalent to 255.255.0.0, etc.

       The second field specifies the reply that oidentd will return for lookups to the host matching the IP address specified in the first param-
       eter.

       The third field specifies the operating system the machine matching the first parameter is running.

EXAMPLES

       <Host>[/<Mask>]		<Ident Response>    <System Type>
       192.168.1.1		     someone		 UNIX
       192.168.1.2		     noone		 WINDOWS
       192.168.1.1/32		     user1		 UNIX
       192.168.1.0/24		     user3		 UNIX
       192.168.0.0/16		     user4		 UNIX
       somehost 		     user5		 UNIX
       192.168.1.0/255.255.255.0     user6		 UNIX

AUTHOR

       Ryan McCabe <ryan@numb.org>
       http://dev.ojnk.net

SEE ALSO

       oidentd(8) oidentd.conf(5)

version 2.0.8							    13 Jul 2003 					      oidentd_masq.conf(5)
All times are GMT -4. The time now is 08:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy