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 302949299 by ashokvpp on Thursday 9th of July 2015 02:02:13 AM
Old 07-09-2015
Regex match date and seconds format
Hi

Code:
$ awk '{print $1," ",$4}' access.log | sort | uniq -c| sort -nr | head -n20
 62 192.168.10.6   [31/May/2015:15:14:40
 62 192.168.10.32   [31/May/2015:19:47:57

How can get the result like
Code:
 62, 192.168.10.6, 14:40
 62, 192.168.10.32, 47:57

I tried modifying -

Code:
$ awk '{print $1," ",$4}' access.log | sort | uniq -c| sort -nr | head -n20 | awk '{print $1","$2}'

- this print 1 and 2 with comma. Now I need the last part i,e min:sec

Thanks
Ash
Last edited by Don Cragun; 07-09-2015 at 03:50 AM.. Reason: Add CODE and ICODE tags.
 

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

aggregate-ios

AGGREGATE-IOS(1)					      General Commands Manual						  AGGREGATE-IOS(1)

NAME

       aggregate-ios - optimise a concatenated set of cisco/IOS prefix filters to help make them nice and short.

SYNOPSIS

       aggregate-ios <source_config >optimised_config

DESCRIPTION

       Takes  cisco IOS configuration on stdin, and optimises any prefix filters found using aggregate(1).  Optimised filters are produced on std-
       out.

OPTIONS

       None.

DIAGNOSTICS

       Any diagnostics produced by aggregate(1) are passed through on stderr.

EXAMPLES

       The following configuration fragment:

	 ip prefix-list AS65530 description Foo, Inc
	 ip prefix-list AS65530 permit 10.1.0.0/16
	 ip prefix-list AS65530 permit 10.2.0.0/16
	 ip prefix-list AS65530 permit 10.2.1.0/24
	 ip prefix-list AS65530 permit 10.3.0.0/16
	 ip prefix-list AS65531 description Bar.Com
	 ip prefix-list AS65531 seq 5 permit 192.168.1.0/24
	 ip prefix-list AS65531 seq 10 permit 192.168.2.0/24
	 ip prefix-list AS65531 seq 15 permit 192.168.0.0/19

       is optimised as follows:

	 ip prefix-list AS65530 permit 10.1.0.0/16 le 24
	 ip prefix-list AS65530 permit 10.2.0.0/15 le 24
	 ip prefix-list AS65531 permit 192.168.0.0/19 le 24

SEE ALSO

       aggregate(1)

HISTORY

       Aggregate-ios was written by Joe Abley <jabley@mfnx.net>.

BUGS

       All those in aggregate(1) and then some :)

Joe Abley							 2000 November 27						  AGGREGATE-IOS(1)
All times are GMT -4. The time now is 09:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy