12-17-2010
How to extract block from a file?
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.
Thanks.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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)
Discussion started by: sskb
5 Replies
2. Shell Programming and Scripting
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)
Discussion started by: Gopal_Engg
2 Replies
3. Shell Programming and Scripting
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)
Discussion started by: dips_ag
6 Replies
4. Shell Programming and Scripting
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)
Discussion started by: marcozd
10 Replies
5. Shell Programming and Scripting
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)
Discussion started by: sandeepk1611
7 Replies
6. UNIX for Advanced & Expert Users
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)
Discussion started by: grep_me
7 Replies
7. Shell Programming and Scripting
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)
Discussion started by: Kesavan
8 Replies
8. Shell Programming and Scripting
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)
Discussion started by: kiki_riki_miki
12 Replies
9. Shell Programming and Scripting
I want to extract XML block surrounding search string
Ex: print XML block for string "myapp1-ear" surrounded by "<application> .. </application>"
Input XML:
<?xml version="1.0" encoding="UTF-8"?>
<deployment-request>
<requestor>
<first-name>kchinnam</first-name>
... (16 Replies)
Discussion started by: kchinnam
16 Replies
10. UNIX for Beginners Questions & Answers
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)
Discussion started by: Pouky
5 Replies
LEARN ABOUT CENTOS
dblink_close
DBLINK_CLOSE(3) PostgreSQL 9.2.7 Documentation DBLINK_CLOSE(3)
NAME
dblink_close - closes a cursor in a remote database
SYNOPSIS
dblink_close(text cursorname [, bool fail_on_error]) returns text
dblink_close(text connname, text cursorname [, bool fail_on_error]) returns text
DESCRIPTION
dblink_close closes a cursor previously opened with dblink_open.
ARGUMENTS
conname
Name of the connection to use; omit this parameter to use the unnamed connection.
cursorname
The name of the cursor to close.
fail_on_error
If true (the default when omitted) then an error thrown on the remote side of the connection causes an error to also be thrown locally.
If false, the remote error is locally reported as a NOTICE, and the function's return value is set to ERROR.
RETURN VALUE
Returns status, either OK or ERROR.
NOTES
If dblink_open started an explicit transaction block, and this is the last remaining open cursor in this connection, dblink_close will
issue the matching COMMIT.
EXAMPLES
SELECT dblink_connect('dbname=postgres');
dblink_connect
----------------
OK
(1 row)
SELECT dblink_open('foo', 'select proname, prosrc from pg_proc');
dblink_open
-------------
OK
(1 row)
SELECT dblink_close('foo');
dblink_close
--------------
OK
(1 row)
PostgreSQL 9.2.7 2014-02-17 DBLINK_CLOSE(3)