Dear experts
I am new bee to scripting...
Pl. help me getting the lines between two strings.
I am getting the oracle sql output as below. and would like to get the time from system date compare with the date in sql output file and extract the lines.
if system time is 2012-07-01 19:15:00 get that time and refer with time available in sql output file "2012-07-01 19:15:01" & "2012-07-01 19:30:01" and extract the lines between these two times "2012-07-01 19:15:01" & "2012-07-01 19:30:01"
how can i achieve this pl. help .. thanks in advance.
Sample SQL file and will be appended every 15 minutes
I need out put to be displayed as below:
Moderator's Comments:
edit by bakunin: this might have happened on an AIX system but it is hardly related to the OS. I am going to transfer this thread to the Scripting board therefore.
For clarification: The OS is implicitly AIX ant the shell ksh.
Hi Friends :)
I have a long file having fields in the form :
Field1 yy/mm/dd hh:mm:ss Duration(Sec)
line 1) 123123 05/11/30 12:12:56 145
line 2) 145235 05/11/30 12:15:15 30
line 3) 145264 05/11/30 13:14:56 178
.
.
I want to... (1 Reply)
Hello friends,
I am looking for a script or method that can display all the dates between any 2 given dates.
Input:
Date 1
290109
Date 2
010209
Output:
300109
310109
Please help me. Thanks. :):confused: (2 Replies)
I have a 1 GB file.I want to take the information for last one month from that file.
Say i want to extract data from May 1st.
File contents below.
193.135.218.124 - - "GET /jsp/acafai/supplier/notification.htm HTTP/1.1" 200 38531
193.135.218.124 - - "GET /images/2_aca_fai.gif HTTP/1.1"... (5 Replies)
Hi all,
this is my first post, and i want to say hello to everyone in there.
I've a little problem for you all :).
I have a log like this:
38714 07/02/09 00:01:36 nsrd web2consolidato:D:\ done saving to pool 'SISTMSW0060' (Q09480) 32 GB
38752 07/02/09 00:01:37 nsrd /dev/rmt/STK0.2.10.5... (5 Replies)
Hi All,
I have files with names as
us_Gec1_wk_01to01_2008.TXT
ad_EngEnt_wk_01to10_2008.TXT
br_EngMov_wk_01to10_2008.TXT
Over here, I need to extract the dates and the year and store them in variables.
How can I achieve the same in bash.
In case of ad_EngEnt_wk_01to10_2008.TXT ... (3 Replies)
Hi Every body
I had a data in file as shown..
Now i want to get the data and insert into other file but between the two date ranges or from a past date to current date..Please Guide me in doing that..
Below is the data that looks like...
child process 2588 still did not exit, sending a... (2 Replies)
Dear all,
Greetings.
I would like to ask for your help to extract lines with specific words in addition 2 lines before and after these lines by using awk or sed.
For example, the input file is:
1 ak1 abc1.0
1 ak2 abc1.0
1 ak3 abc1.0
1 ak4 abc1.0
1 ak5 abc1.1
1 ak6 abc1.1
1 ak7... (7 Replies)
I have hundreds of files to process. In each file
I need to look for a pattern then
extract value(s) from next line and then
search for value(s) selected from point (2) in the same file at a specific position.
HEADER ELECTRON TRANSPORT 18-MAR-98 1A7V
TITLE CYTOCHROME... (7 Replies)
Data file example
I look for primary and * to isolate the interesting slot number.
slot=`sed '/^primary$/,/\*/!d' filename | tail -1 | sed s'/*//' | awk '{print $1" "$2}'`
Now I want to get the Touch line for only the associate slot number, in this case, because the asterisk... (2 Replies)
I have some test data that is seperated out into annual records, each record has a start date (COL7), an end date (COL8) and a maturity date (COL18) - What I need to do is ensure that there is one record to cover each year right up until Maturity date (COL18).
In the first group of the below... (10 Replies)