Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extracting lines in file based on time
Top Forums Shell Programming and Scripting Extracting lines in file based on time Post 302334948 by rakeshawasthi on Friday 17th of July 2009 12:49:53 AM
Old 07-17-2009
Assuming Jun 18 does not change, and only time stame HH:MI:SS is considered
Try:
Code:
#!/bin/ksh
#set -x

_minPrev=15
_currTimeInSec=$(echo `date "+%T"` | awk -F":" '{print $1*3600+$2*60+$3}')
(( _prevTimeInSec = ${_currTimeInSec} - (0+60*${_minPrev}+0) ))

while read line
do
   _timeInFile=$(echo $line | awk '{FS="[: ]+"}{print $3*3600+$4*60+$5}')

   if [[ ${_timeInFile} -ge ${_prevTimeInSec} && ${_timeInFile} -le ${_currTimeInSec} ]]; then
      echo $line
   fi
done < input


I think extending it for MM and DD should not be an issue for you.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove lines, Sorted with Time based columns using AWK & SORT

Hi having a file as follows MediaErr.log 84 Server1 Policy1 Schedule1 master1 05/08/2008 02:12:16 84 Server1 Policy1 Schedule1 master1 05/08/2008 02:22:47 84 Server1 Policy1 Schedule1 master1 05/08/2008 03:41:26 84 Server1 Policy1 ... (1 Reply)
Discussion started by: karthikn7974
1 Replies

2. Shell Programming and Scripting

awk : extracting unique lines based on columns

Hi, snp.txt CHR_A SNP_A BP_A_st BP_A_End CHR_B BP_B SNP_B R2 p-SNP_A p-SNP_B 5 rs1988728 74904317 74904318 5 74960646 rs1427924 0.377333 0.000740085 0.013930081 5 ... (12 Replies)
Discussion started by: genehunter
12 Replies

3. Shell Programming and Scripting

Extracting specific lines of data from a file and related lines of data based on a grep value range?

Hi, I have one file, say file 1, that has data like below where 19900107 is the date, 19900107 12 144 129 0.7380047 19900108 12 168 129 0.3149017 19900109 12 192 129 3.2766666E-02 ... (3 Replies)
Discussion started by: Wynner
3 Replies

4. Shell Programming and Scripting

Extracting few lines from a file based on identifiers dynamically

i have something like this in a file called mysqldump.sql -- -- Table structure for table `Table11` -- DROP TABLE IF EXISTS `Table11`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Table11` ( `id` int(11) NOT NULL... (14 Replies)
Discussion started by: vivek d r
14 Replies

5. Shell Programming and Scripting

Extracting lines based on identifiers into multiple files respectively

consider the following is the contents of the file cat 11.sql drop procedure if exists hoop1 ; Delimiter $$ CREATE PROCEDURE hoop1(id int) BEGIN END $$ Delimiter ; . . . . drop procedure if exists hoop2; Delimiter $$ CREATE PROCEDURE hoop2(id int) BEGIN END $$ (8 Replies)
Discussion started by: vivek d r
8 Replies

6. Shell Programming and Scripting

extracting lines based on condition and copy to another file

hi i have an input file that contains some thing like this aaa acc aa abc1 1232 aaa abc2.... poo awq aa abc1 aaa aaa abc2 bbb bcc bb abc1 3214 bbb abc3.... bab bbc bz abc1 3214 bbb abc3.... vvv ssa as abc1 o09 aaa abc4.... azx aaq aa abc1 900 aqq abc19.... aaa aa aaaa abc1 899 aa... (8 Replies)
Discussion started by: anurupa777
8 Replies

7. UNIX for Dummies Questions & Answers

Extracting lines from a text file based on another text file with line numbers

Hi, I am trying to extract lines from a text file given a text file containing line numbers to be extracted from the first file. How do I go about doing this? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

8. Shell Programming and Scripting

Extracting log files based on date and time.

Hi All, i have some log files generated in a folder daily with the format abc.def.20130306.100001 ghi.jkl.20130306.100203 abc.def.20130305.100001 ghi.jkl.20130305.100203 the format is the date followed by time . all i want is to get the files that are generated for todays... (3 Replies)
Discussion started by: mahesh300182
3 Replies

9. Shell Programming and Scripting

Extracting lines from text files in folder based on the numbers in another file

Hello, I have a file ff.txt that looks as follows *ABNA.txt 356 24 36 112 *AC24.txt 457 458 321 2 ABNA.txt and AC24.txt are the files in the folder named foo1. Based on the numbers in the ff.txt file, I want to extract the lines from the corresponding files in the foo1 folder and... (2 Replies)
Discussion started by: mohamad
2 Replies

10. Shell Programming and Scripting

Extracting words and lines based on keywords

Hello! I'm trying to process a text file and am stuck at 2 extractions. Hoping someone can help me here: 1. Given a line in a text file and given a keyword, how can I extract the word preceeding the keyword using a shell command/script? For example: Given a keyword "world" in the line: ... (2 Replies)
Discussion started by: seemad
2 Replies

LEARN ABOUT DEBIAN

k5identity

.K5LOGIN(5)							File Formats Manual						       .K5LOGIN(5)

NAME

       .k5identity - Kerberos V5 client principal selection rules

DESCRIPTION

       The  .k5identity  file,	which  resides in a user's home directory, contains a list of rules for selecting a client principals based on the
       server being accessed.  These rules are used to choose a credential cache within the cache collection when possible.

       Blank lines and lines beginning with '#' are ignored.  Each line has the form:

	      principal field=value ...

       If the server principal meets all of the field constraints, then principal is chosen as the client principal.   The  following  fields  are
       recognized:

       realm  If the realm of the server principal is known, it is matched against value, which may be a pattern using shell wildcards.  For host-
	      based server principals, the realm will generally only be known if there is a domain_realm section in krb5.conf with a  mapping  for
	      the hostname.

       service
	      If  the  server  principal  is  a host-based principal, its service component is matched against value, which may be a pattern using
	      shell wildcards.

       host   If the server principal is a host-based principal, its hostname component is converted to lower  case  and  matched  against  value,
	      which may be a pattern using shell wildcards.

       If  the	server	principal matches the constraints of multiple lines in the .k5identity file, the principal from the first matching line is
       used.  If no line matches, credentials will be selected some other way, such as the realm heuristic or the current primary cache.

EXAMPLE

       The following example .k5identity file selects the client principal alice@KRBTEST.COM if the server principal is  within  that  realm,  the
       principal  alice/root@EXAMPLE.COM if the server host is within a servers subdomain, and the principal alice/mail@EXAMPLE.COM when accessing
       the IMAP service on mail.example.com.

	      alice@KRBTEST.COM       realm=KRBTEST.COM
	      alice/root@EXAMPLE.COM  host=*.servers.example.com
	      alice/mail@EXAMPLE.COM  host=mail.example.com service=imap

SEE ALSO

       kerberos(1), krb5.conf(5)

																       .K5LOGIN(5)
All times are GMT -4. The time now is 01:30 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy