I have siebel log file as following
EventContext .......
123
.......
SELECT
...
..
EventConext <---- Question 1 , I should get this line
345
......
SELECT <----- Question 2 , print this line
Test..... <----- Question 2 , print this line
.... <----- Question 2 , print this line
ID 16318020: 111.678 seconds <----- Question 2 , print this line
SELECT
.......
1. Here all I know is string "ID 16318020: 111.678 seconds". I want to print EventContext line before this string(there may be more occurance of EventContext but I want to print only the first previous occurance from this line.
2. Also I have need to print block of SQL that start with last SELECT (one before string ID 16318020) and ending with ID 16318020.
e.g
SELECT
Test.....
....
ID 16318020: 111.678 seconds
I am sure some Guru will help me to solve this problem.
Location: Saint Paul, MN USA / BSD, CentOS, Debian, OS X, Solaris
Posts: 2,288
Thanks Given: 430
Thanked 480 Times in 395 Posts
Hi.
Here is an alternate solution. The nonstandard cgrep allows one to specify the edges of a window around a regular expression. The window edges may themselves be specified as regular expressions. So we can tell cgrep to look for the line matching the last line of interest, and then go backwards to find the preceding line of interest.
Then the sub-block needs to be deleted except for the first and last lines -- again a set of bounds or edges.
In the middle of this script is the call to cgrep, piped into a short perl script to do the sub-block work:
which, when run, produces:
As it turns out, extracting and deleting blocks is a common task, so one might create a script to do that based on parameters.
Changing the operative lines to do that in a script s3:
produces:
Best wishes ... cheers, drl
The source for cgrep can be found at: http://sourceforge.net/projects/cgrep/
Location: Saint Paul, MN USA / BSD, CentOS, Debian, OS X, Solaris
Posts: 2,288
Thanks Given: 430
Thanked 480 Times in 395 Posts
Hi, Mac91.
Quote:
Originally Posted by Mac91
I want to know the use of system function in linux and also the difference between system() and backtrick term?
Welcome to the forum.
Your question will probably not receive much attention because you tacked it onto a thread that has already been answered and has nothing to do with your problem.
I suggest you start a new thread with your question.
You can do that by going to the head of this sub-forum (shell programming-scripting) and clicking the New Thread button ... cheers, drl
Hi everyone,
So i'm struggling with an xml (log file) where we get information about some devices, so the logfile is filled with multiple "blocks" like that.
Based on the <devId> i want to extract this part of the xml file. If possible I want it to have an script for this, cause we'll use... (5 Replies)
Hello all,
I am working on a script which should parse a large file called input.txt which contains table definitions, index definitions and comments like these ones:
------------------------------------------------
-- DDL Statements for table "CMWSYS"."CMWD_TEC_SUIVI_TRT"... (12 Replies)
I want to process a file block by block using sed, and if that block does not contain two patterns, then that complete block has to be printed.
See below for the example data.
................................server 1...............................
running process 1
running... (8 Replies)
I have a "main" file which has blocks of data for each user defined by tags BEGIN and END.
BEGIN
ID_NUM:24879
USER:abc123
HOW:47M
CMD1:xyz1
CMD2:arp2
STATE:active
PROCESS:id60
END
BEGIN
ID_NUM:24880
USER:def123
HOW:4M
CMD1:xyz1
CMD2:xyz2
STATE:running
PROCESS:id64
END (7 Replies)
Hi,
I have some CVS log files, which are divided into blocks. Each block has many fields of information and I want to extract those blocks with a pattern. Here is the sample input.
RCS file: /cvsroot/eclipse/org.eclipse.debug.core/core/org/eclipse/debug/core/DebugPlugin.java,v
head: 1.174... (7 Replies)
Hello all,
I have a large output file from which I would like to extract a single block of text.
An example block of text is shown below:
***** EQUILIBRIUM GEOMETRY LOCATED *****
COORDINATES OF ALL ATOMS ARE (ANGS)
ATOM CHARGE X Y Z
... (10 Replies)
Hi,
There's an xml file produced from a front-end tool as shown below:
<INPUT DATABASE ="ORACLE" DBNAME ="UNIX" NAME ="FACT_TABLE" OWNERNAME ="DIPS">
<INPUTFIELD DATATYPE ="double" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="STORE_KEY" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="15" SCALE... (6 Replies)
Hi , this is my first enty in our forum.
Problem scenario:
Using informatica tool am loding records from source DB to target DB. While loading some records getting rejected due to some reason. Informatica will capture those rejected records in session log file.now the session log ll be... (2 Replies)
I need to extract a particular block from a file whose locations are not known but the only identity is a word. For example
in a file I have
ABC
asdklf
asdfk
FGH
dfdfg
asdlfk
asdfl
...
JHK (5 Replies)