Extract multiple line text from log between special words

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Shell - Read a text file with two words and extract data

hi I made this simple script to extract data and pretty much is a list and would like to extract data of two words separated by commas and I would like to make a new text file that would list these extracted data into a list and each in a new line. Example that worked for me with text file...

2. Shell Programming and Scripting

Search words in multiple file line by line

Hi All I have to search servers name say like 1000+ "unique names" line by line in child.txt files in another file that is a master file where all server present say "master.txt",if child.txt's server name matches with master files then it print yes else no with server name.

3. Shell Programming and Scripting

USING sed to remove multiple strings/words from a line

Hi I use sed comnand to remove occurance of one workd from a line. However I need to removed occurance of dufferent words in ne line. Original-1 Hi this is the END of my begining Comand sed s/"END"/"start"/g Output-1 Hi this is the start of my beginig But I have more...

4. Shell Programming and Scripting

I need to extract uique words from text file

Hello programmers, I need to create a list of unique words from a text file using PERL...may i have the code for that please? Thank you

5. Shell Programming and Scripting

Combine multiple unique lines from event log text file into one line, use PERL or AWK?

I can't decide if I should use AWK or PERL after pouring over these forums for hours today I decided I'd post something and see if I couldn't get some advice. I've got a text file full of hundreds of events in this format: Record Number : 1 Records in Seq : ...

6. UNIX for Dummies Questions & Answers

Searching for multiple words on a line in any order issue

Hi again I have figured out how to be able to sort through lines in a file with multiple words in any order and display them using this command: cat file | grep -i $OPTION1 | grep -i $OPTION2 | grep -i $OPTION3 OPTION1 is 2008, OPTION2 is Mar, OPTION 3 is Tue Result: Tue Mar 25...

7. UNIX for Dummies Questions & Answers

extract text between two words on a single line

Hi Guys, Can someone help me with a way to extract text between two words on a single line. For example if the file has below content I want to extract all text between b and f inclusive of b and f. Aparently sed does this but does it line by line and I guess it cannot read word by word. ...

8. Shell Programming and Scripting

Extract X words from end of line, minus last keynumber X

The file contains one line of text followed by a number. I want to take the number X at the end, take it out and display the last X words. X is the key telling me how many words from the end that I want and X will always be less than the number of words, so no problem there. Example input and...

9. Shell Programming and Scripting

grep multiple words in a single line

Hi.. How to search for multiple words in a single line using grep?. Eg: Jack and Jill went up the hill Jack and Jill were best friends Humpty and Dumpty were good friends too ---------- I want to extract the 2nd statement(assuming there are several statements with...

10. Shell Programming and Scripting

grep on multiple words to match text template

hi, I have few text templates as a simple ex: template 1 city Name: zip code: state Name: template2: employee Name: Phone number: I wish to grep on given text file and make sure the text file matches one of these templates. Please give your ideas.

LEARN ABOUT PHP

oci_parse

OCI_PARSE(3)															      OCI_PARSE(3)

oci_parse - Prepares an Oracle statement for execution

SYNOPSIS

       resource oci_parse (resource  $connection, string  $sql_text)

DESCRIPTION

	Prepares  $sql_text using $connection and returns the statement identifier, which can be used with oci_bind_by_name(3), oci_execute(3) and
       other functions.

	Statement identifiers can be freed with oci_free_statement(3) or by setting the variable to NULL.

PARAMETERS

	      o $connection
		- An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).

	      o $sql_text
		- The SQL or PL/SQL statement.	SQL statements should not end with a semi-colon (";"). PL/SQL statements should end with  a  semi-
		colon (";").

RETURN VALUES

	Returns a statement handle on success, or FALSE on error.

EXAMPLES

       Example #1

	      oci_parse(3) example for SQL statements

	      <?php

	      $conn = oci_connect('hr', 'welcome', 'localhost/XE');

	      // Parse the statement. Note there is no final semi-colon in the SQL statement
	      $stid = oci_parse($conn, 'SELECT * FROM employees');
	      oci_execute($stid);

	      echo "<table border='1'>
";
	      while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
		  echo "<tr>
";
		  foreach ($row as $item) {
		      echo "	<td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : "&nbsp;") . "</td>
";
		  }
		  echo "</tr>
";
	      }
	      echo "</table>
";

	      ?>

       Example #2

	      oci_parse(3) example for PL/SQL statements

	      <?php

	      /*
		Before running the PHP program, create a stored procedure in
		SQL*Plus or SQL Developer:

		CREATE OR REPLACE PROCEDURE myproc(p1 IN NUMBER, p2 OUT NUMBER) AS
		BEGIN
		    p2 := p1 * 2;
		END;

	      */

	      $conn = oci_connect('hr', 'welcome', 'localhost/XE');
	      if (!$conn) {
		  $e = oci_error();
		  trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
	      }

	      $p1 = 8;

	      // When parsing PL/SQL programs, there should be a final semi-colon in the string
	      $stid = oci_parse($conn, 'begin myproc(:p1, :p2); end;');
	      oci_bind_by_name($stid, ':p1', $p1);
	      oci_bind_by_name($stid, ':p2', $p2, 40);

	      oci_execute($stid);

	      print "$p2
";   // prints 16

	      oci_free_statement($stid);
	      oci_close($conn);

	      ?>

NOTES

       Note

	       This  function  does not validate $sql_text. The only way to find out if $sql_text is a valid SQL or PL/SQL statement is to execute
	      it.

SEE ALSO

       oci_execute(3), oci_free_statement(3).

PHP Documentation Group 													      OCI_PARSE(3)

Shell Programming and Scripting