You could get some more efficiency by not calling the date external on each input line and using bash to convert the date time to an mmddHHMMSS number for direct comparison like this:
If file is sorted you can save processing additional lines by using break instead of continue once you are past the target datetime.
Edit: This will have issues around end of calendar year where Dec 31 will appear to be greater than Jan 1
Last edited by Chubler_XL; 01-29-2020 at 04:39 PM..
This User Gave Thanks to Chubler_XL For This Post:
how to copy lines from a log file based on timestamp.
INFO (RbrProcessFlifoEventSessionEJB.java:processFlight:274) - E_20080521_110754_967: rbrAciInfoObjects listing complete!
INFO (RbrPnrProcessEventSessionEJB.java:processFlight:197) - Event Seq: 1647575217; Carrier: UA; Flt#: 0106; Origin:... (1 Reply)
I am trying to find a way to list every records inside a file (usually a log file) that are present after a record mathing/greater-then a timestamp supplied by another script.
The timestamp can be anywhere inside the record and it is usually in the standard `date` format (will not look for other... (5 Replies)
I have a file which is having fileds separtaed by delimiter.
Ex:
C;4498;qwa;cghy;;;;40;;222122
C;4498;sample;city;;;;34 2;;222123
C;4498;qwe;xcbv;;;;34-2;;222124
C;4498;jj;sffz;;;;41;;222120
C;4498;eert;qwq;;;;34 A;;222125
C;4498;jj;szxzzd;;;;34;;222127
out of these records I... (3 Replies)
I want to filter records in one of my file using AWK command (or anyother command). I am using the below code
awk -F@ '$1=="0003"&&"$2==20100402" print {$0}' $INPUT > $OUTPUT
I want to pass the 0003 and 20100402 values through a variable. How can I do this?
Any help is much... (1 Reply)
I have a log file which has records with hung thread information/error
I need to find out hung thread from log file greater than timestamp supplied.
00000026 ThreadMonitor W WSVR0605W: Thread "WebContainer : 1" (00000027) has been active for 701879 milliseconds and may be hung. There is/are... (6 Replies)
Hello,
I want to filter records of a file if they fall in range associated with a second file. First the chr number (2nd col of 1st file and 1st col of 2nd file) needs to be matched. Then if the 3rd col of the first file falls within any of the ranges specified by the 2nd and 3rd cols , then... (4 Replies)
Hi Folks,
I have a text file with lots of rows with duplicates in the first column, i want to filter out records based on filter columns in a different filter text file.
bash scripting is what i need.
Data.txt
Name OrderID Quantity
Sam 123 300
Jay 342 498
Kev 78 2500
Sam 420 50
Vic 10... (3 Replies)
Not sure if this is the correct forum for this question. I have two files. file1.zip, file2
Input:
file1.zip
col1, col2 , col3
a , b , 0:0:0:0:0:c436:9346:d40b
x, y, 0:0:0:0:0:880:39f9:c9a7
m, n , 0:0:0:0:0:80c7:9161:fe00
file2.txt
col1
c4:36:93:46:d4:0b... (1 Reply)
I have two files and would need to filter out records based on certain criteria, these column are of variable lengths, but the lengths are uniform throughout all the records of the file. I have shown a sample of three records below. Line 1-9 is the item number "0227546_1" in the case of the first... (15 Replies)
Discussion started by: MIA651
15 Replies
LEARN ABOUT DEBIAN
xcalev
XCALEV(1) General Commands Manual XCALEV(1)NAME
xcalev - load xcal calendar files with regular dates
SYNTAX
xcalev [ -r ][ -x ][ -f file ][ -d dir ][ year ]
DESCRIPTION
Xcalev is used to preload the calendar files for the xcal program with regular events in your life. It reads lines from a file (usually
called regular stored in your Calendar directory. Each line in the file contains three fields separated by spaces or tabs, these are: a
month name, a day in the month and some text. For example:
December 25 Christmas
Dec 31 New Year's Eve
The order of the month and the day are optional, the program deduces the day by looking whether the string contains an initial numeric
character or not. The year defaults to the current year unless the program is given a year number as an argument. This year cannot be
abbreviated to two digits because xcal
deals with years from year zero. There's a rough validity check on this.
The string from the data line is inserted in the appropriate file and will appear in your xcal date strip. Nothing will happen if the
string already exists in the file for that day. This means that it's safe to run xcalev at any time, only the strings that have altered in
the regular file will be updated.
To help with entering the same event for a number of days in one month, you can give a day range with a hyphen
Jan 16-21 Usenix SF
If you supply the -r option, xcalev will delete all the matching strings that it finds in the appropriate daily file. So, if you want to
make radical changes to the regular file, you should run xcalev with the -r option to remove all the current entries from one year, edit
the regular file and run xcalev to reload things.
OPTIONS
The -r option makes xcalev delete rather than append entries.
The -x option makes xcalev operate with Calendar files that are compatible with the xcalendar program.
The -f switch is followed by a filename gives an alternative name for the regular file. If the filename does not start with a slash or a
dot, then the name of your Calendar directory will be prepended to it.
The -d switch is followed by a directory name and specifies an alterative location for your Calendar directory. Your home directory is
prepended if the name doesn't start with a slash or a dot.
FILES
$HOME/Calendar/*
xc<dd><Mon><Year> A data file is day, Month in three letter format and the year.
xy<Year> A year directory.
xw<Day> A data file for the weekly code, one per day.
SEE ALSO xcal(1), xcalpr(1), xcal_cal(1)AUTHOR
Copyright 1993 by Peter Collinson, Hillside Systems All rights reserved.
X Version 11 R5 October 1993 XCALEV(1)