07-25-2013
Sorting data file by date and time
Here is some samples of the field I have to sore by in the data file:
7/25/2013 6:35:34 AM
10/25/2013 6:35:34 AM
7/2/2013 6:35:34 AM
7/25/2013 10:35:34 AM
7/25/2013 6:35:34 PM
There are at least 4 different possibilities, with many combinations
1 and 2 digit month
1 and 2 digit day
1 and 2 digit hour
AM and PM
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi guys... I've been trying to do this for ages. Maybe you can help.
I have log files like the examples below and I have grepped out certain lines from the files so that I can get an idea of who is logging on and how. So now I have the information in a new file but it is now in a different order... (7 Replies)
Discussion started by: padmundo
7 Replies
2. Shell Programming and Scripting
Hi,
I'm trying to accomplish the following and would like some suggestions or possible bash script examples that may work
I have a directory that has a list of log files that's periodically dumped from a script that is crontab that are rotated 4 generations. There will be a time stamp that is... (4 Replies)
Discussion started by: primp
4 Replies
3. Shell Programming and Scripting
I want a shell script which extract data from a log file which contains date and time-wise data and i need the data for a perticular interval of time...what can i do??? (3 Replies)
Discussion started by: abhishek27
3 Replies
4. UNIX and Linux Applications
I'm not sure if this really belongs anywhere on this forum but my previous experiences on here have shown me that you guys are very helpful so I figure I may as well try.
I have a bunch of large 2d arrays in matlab and each has a column for a date that each row corresponds to. The format is... (1 Reply)
Discussion started by: skray
1 Replies
5. Shell Programming and Scripting
Hi all,
I have logs(in a log file) with the following structure
20100916011501559;0.812;null;TRUE;;FALSE;0.812;0;0;;19
20100916011504762;0.015;null;TRUE;;FALSE;0;4|4;0.015;;4
20100916011504762;0;null;TRUE;;FALSE;0;0;0;;4
20100916011501731;3.343;null;TRUE;;FALSE;3.156;131|65;0.172;;11... (14 Replies)
Discussion started by: babai
14 Replies
6. Shell Programming and Scripting
i have two files with identical no of columns. 6th columns is date (MM/DD/YY format) and 7th columns is time (HH:MM:SS) format. I need to compare these two vaules and if the date & time is higher than fileA, save it on fileC; if the value is lower, then save it on fileD
CONDITIONS... (7 Replies)
Discussion started by: ajiwww
7 Replies
7. Shell Programming and Scripting
Hi Guys!
i have a problem of sorting column chronologically because the data i have in column is in the following format
06/Dec/2006:18:09:54
and need to be sorted in the following way (upto seconds)
06/Dec/2005:18:09:50
06/Dec/2005:18:09:51
31/Mar/2006:19:30:41
24/Oct/2006:19:16:19... (4 Replies)
Discussion started by: me_newbie
4 Replies
8. Shell Programming and Scripting
Hi,
PFB the data:
C_Random_130417
Java_Random_130518
Perl_Random_120519
Perl_Random_120528
so the values are ending with year,i.e.,130417
i want to sort the values with date.
i want the output like this:
Perl_Random_120519
Perl_Random_120528
C_Random_130417
Java_Random_130518
can... (5 Replies)
Discussion started by: arindam guha
5 Replies
9. UNIX for Dummies Questions & Answers
I have file having below data
01-MAY-13 2.38.11.00.100089 IN 4512 0000741881
01-JUN-13 2.38.11.00.100089 IN 1514 0000764631
01-NOV-13 2.38.11.00.100089 IN 1514 0000856571
01-NOV-13 2.38.15.00.100015 IN 300.32 0000856531
01-JUN-13 2.38.19.00.100000 IN 2698 0000764493
01-JUL-13... (2 Replies)
Discussion started by: ranabhavish
2 Replies
10. Shell Programming and Scripting
I have file a.txt having below data
cat a.txt
01-MAY-13 2.38.11.00.100089 IN 4512 0000741881
01-JUN-13 2.38.11.00.100089 IN 1514 0000764631
01-NOV-13 2.38.11.00.100089 IN 1514 0000856571
01-NOV-13 2.38.15.00.100015 IN 300.32 0000856531
01-JUN-13 2.38.19.00.100000 IN 2698 0000764493... (5 Replies)
Discussion started by: ranabhavish
5 Replies
LEARN ABOUT XFREE86
getdate
GETDATE(1) User Commands GETDATE(1)
NAME
getdate - AME
SYNOPSIS
[-dv][-n dec][-f format] [ra dec sys] itype2otype [date and/or time]
DESCRIPTION
Convert date and time between various formats
[-dv][-n dec][-f format] itype2otype @file
itype: nfd=ISOFITS fd=FITS, dt=yyyy.mmdd, hr=hh:mm:ss, deg=dd:mm:ss
jd=Julian Date, mjd=Modified Julian Date hjd=Heliocentric Julian Date, mhjd=Modified HJD ep=epoch, epj=Julian epoch, epb=Besselian
epoch lt=local time, ut=UT, ts=seconds since 1950-01-01 now=current time, ang=fractional degrees
otype: fd=FITS, dt=yyyy.mmdd, jd=Julian Date, mjd=Modified Julian Date
hjd=Heliocentric Julian Date, mhjd=Modified HJD hr=hh:mm:ss, deg=dd:mm:ss, ang=fractional degrees ep=epoch, epj=Julian epoch,
epb=Besselian epoch ts=seconds since 1950-01-01, tsu=Unix sec, tsi=IRAF sec gst=Greenwich Sidereal Time, lst=Local Sidereal Time
@file: First one or two columns are in itype format ra dec sys: Need for Heliocentric conversions
-a: Append date to input file, if there is one
-d: Print date without time
-e: Print output as ET/TDT/TT converting from UT
-f: Format for output number (C printf)
-h hours: Longitude in hours, west positive
-l degrees: Longitude in degrees, west positive
-n: Number of decimal places in sec, epoch, JD
-t: Print time without date
-v: Verbose
getdate 3.8.4 June 2012 GETDATE(1)