11-08-2011
Thanks but i need the entire records - not the date/time part and also your out put has AM/PM which is not needed .
Ex. Input records :
Nov 2 2011 12:01AM,52893,420,1,4,0,52834,4,1208,67664942,603459924403.0,1,150054,1208,3
Nov 2 2011 5:05PM,52127,420,1,4,0,52122,4,1283,151823875,603459924404.0,1,150054,1283,3
Expected out put records:
Nov 2 2011 12:01,52893,420,1,4,0,52834,4,1208,67664942,603459924403.0,1,150054,1208,3
Nov 2 2011 17:05,52127,420,1,4,0,52122,4,1283,151823875,603459924404.0,1,150054,1283,3
If my perl script can be modified to match the records or same sed command equivalent than it will be fine.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hello,
does somebody knows about a function that would convert a date like:
YYMMDD into a date like YYYY-MM-DD ?
Thank you for your ideas
:) (9 Replies)
Discussion started by: Cecile
9 Replies
2. Windows & DOS: Issues & Discussions
help me to convert unix time format into windows time format using java
i have linux time ex. 1075329297.572 (2 Replies)
Discussion started by: sari
2 Replies
3. Shell Programming and Scripting
I have a file named "suspected" with series of line like these :
{'protocol': 17, 'service': 'BitTorrent KRPC', 'server': '219.78.120.166', 'client_port': 52044, 'client': '10.64.68.44', 'server_port': 8291, 'time': 1226506312L, 'serverhostname': ''}
{'protocol': 17, 'service': 'BitTorrent... (3 Replies)
Discussion started by: rk4k
3 Replies
4. UNIX for Dummies Questions & Answers
hi,
i have a file in which i get date format as 22/APR/2010...
now i want the date format to be in 22-04-2010
if the month changes to may the file should also have 05 as month....
pls help (3 Replies)
Discussion started by: siva_nagarajan
3 Replies
5. Shell Programming and Scripting
Hi All,
Can someone please let me know how can i convert the date format in unix as follow:
From: 24 Oct 2011
i.e $(date +'%d %b %Y')
To: 111024
i.e $(date +%y%m%d)
Thanks in advance (3 Replies)
Discussion started by: davidtd
3 Replies
6. Shell Programming and Scripting
hi i want to convert date procured from sone operation which will be in 24hr format to 12 hr format displaying AM and PM
# date -d @1362545068
Tue Mar 5 23:44:28 EST 2013
#
this Tue Mar 5 23:44:28 EST 2013
i want to convert it so that output is as below
Tue... (2 Replies)
Discussion started by: vivek d r
2 Replies
7. Shell Programming and Scripting
Hello ,
I have a record in below format
Hostname | Query: 0 | Release: 0 | files: 2 | Files_examined: 2 | SET timestamp=1396778638; | select * from test
I need output in below format
Hostname | 0 | 0 | 2 | 2 | 04/06/2014|03:03:58 | select * from test
I was able to get above output... (1 Reply)
Discussion started by: Tomlight
1 Replies
8. Shell Programming and Scripting
Hi,
i have to check the file whether it is created today. here is the ls -l o/p
-rw-r----- 20000 50000 130 Dec 12 10:21 file.txt
im able to check if file is created today or not if the timestamp is in 2014-12-12 format by comparing $(date +Y-%m-%d)
but stuckup as it is of format Dec 12... (6 Replies)
Discussion started by: JSKOBS
6 Replies
9. Shell Programming and Scripting
I have a script below and wanted to change the output into three different file format (3 separate script)
#!bin/bash
#input file format postwrf_d01_20131206_0600_f08400.grb2
#postwrf_d01_YYYYMMDD_ZZZZ_f0HHHH.grb2
#zzzz= 0000,0600,1200,1800 (in UTC)
#HHHH=00000,00600,01200,01800 ..ect (in... (1 Reply)
Discussion started by: cumulus_255
1 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I have a file where I need to change the date format on the nth field from DD-MM-YYYY to YYYY-MM-DD so I can accurately sort the record by dates
From regex - Use sed or awk to fix date format - Stack Overflow, I found an example using nawk.
Test run as below:
$: cat xyz.txt
A ... (2 Replies)
Discussion started by: newbie_01
2 Replies
LEARN ABOUT OSX
curl_getdate
curl_getdate(3) libcurl Manual curl_getdate(3)
NAME
curl_getdate - Convert a date string to number of seconds since January 1, 1970
SYNOPSIS
#include <curl/curl.h>
time_t curl_getdate(char *datestring, time_t *now );
DESCRIPTION
This function returns the number of seconds since January 1st 1970 in the UTC time zone, for the date and time that the datestring parame-
ter specifies. The now parameter is not used, pass a NULL there.
NOTE: This function was rewritten for the 7.12.2 release and this documentation covers the functionality of the new one. The new one is not
feature-complete with the old one, but most of the formats supported by the new one was supported by the old too.
PARSING DATES AND TIMES
A "date" is a string containing several items separated by whitespace. The order of the items is immaterial. A date string may contain
many flavors of items:
calendar date items
Can be specified several ways. Month names can only be three-letter english abbreviations, numbers can be zero-prefixed and the
year may use 2 or 4 digits. Examples: 06 Nov 1994, 06-Nov-94 and Nov-94 6.
time of the day items
This string specifies the time on a given day. You must specify it with 6 digits with two colons: HH:MM:SS. To not include the time
in a date string, will make the function assume 00:00:00. Example: 18:19:21.
time zone items
Specifies international time zone. There are a few acronyms supported, but in general you should instead use the specific relative
time compared to UTC. Supported formats include: -1200, MST, +0100.
day of the week items
Specifies a day of the week. Days of the week may be spelled out in full (using english): `Sunday', `Monday', etc or they may be
abbreviated to their first three letters. This is usually not info that adds anything.
pure numbers
If a decimal number of the form YYYYMMDD appears, then YYYY is read as the year, MM as the month number and DD as the day of the
month, for the specified calendar date.
EXAMPLES
Sun, 06 Nov 1994 08:49:37 GMT
Sunday, 06-Nov-94 08:49:37 GMT
Sun Nov 6 08:49:37 1994
06 Nov 1994 08:49:37 GMT
06-Nov-94 08:49:37 GMT
Nov 6 08:49:37 1994
06 Nov 1994 08:49:37
06-Nov-94 08:49:37
1994 Nov 6 08:49:37
GMT 08:49:37 06-Nov-94 Sunday
94 6 Nov 08:49:37
1994 Nov 6
06-Nov-94
Sun Nov 6 94
1994.Nov.6
Sun/Nov/6/94/GMT
Sun, 06 Nov 1994 08:49:37 CET
06 Nov 1994 08:49:37 EST
Sun, 12 Sep 2004 15:05:58 -0700
Sat, 11 Sep 2004 21:32:11 +0200
20040912 15:05:58 -0700
20040911 +0200
STANDARDS
This parser was written to handle date formats specified in RFC 822 (including the update in RFC 1123) using time zone name or time zone
delta and RFC 850 (obsoleted by RFC 1036) and ANSI C's asctime() format. These formats are the only ones RFC2616 says HTTP applications may
use.
RETURN VALUE
This function returns -1 when it fails to parse the date string. Otherwise it returns the number of seconds as described.
If the year is larger than 2037 on systems with 32 bit time_t, this function will return 0x7fffffff (since that is the largest possible
signed 32 bit number).
Having a 64 bit time_t is not a guarantee that dates beyond 03:14:07 UTC, January 19, 2038 will work fine. On systems with a 64 bit time_t
but with a crippled mktime(), curl_getdate will return -1 in this case.
REWRITE
The former version of this function was built with yacc and was not only very large, it was also never quite understood and it wasn't pos-
sible to build with non-GNU tools since only GNU Bison could make it thread-safe!
The rewrite was done for 7.12.2. The new one is much smaller and uses simpler code.
libcurl 7.0 12 Aug 2005 curl_getdate(3)