find 2 line numbers, grab text in between - Shell Programming and Scripting

Da_Duck · #1 09-26-2006

hi, i have a large text file that I just want to extract the important
information from. It will be a random number of lines but between two specific
line numbers/markers.

I was thinking I could get the line number for the first marker:
Tablespace Percent Total Free

Then get the line number for the second marker:
Tablespace Free Space Avg Fragmentation

Now all I would need to do is print out the text between the two lines
(including the 1st marker but not the second):
print 1st_marker_line# --> 2nd_marker_line#

I am pretty sure I can do this with awk but not sure how.
Thanks for your help!

Sample text:

PHP Code:


			
09/25/06      SPCCHK - Tablespace Percent Total Free Values on SWB

                                                                   %chg Days

Tablespace                                                  Today since till

   Name           09/18 09/19 09/20 09/21 09/22 09/23 09/24 09/25  yest zero

----------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----

BDR_DATA           89.5  89.5  89.4  89.4  89.4  89.3  89.3  89.1   -.2

SYSAUX             71.0  70.5  70.0  71.5  71.1  70.6  70.0  71.4   1.4

SYSTEM             22.7  22.7  22.7  22.7  22.7  22.6  22.2  22.2    .0  297

UNDOTBS1           21.8  21.8  22.5  31.0  30.8  29.8  29.9  30.9   1.0



09/25/06  SPCCHK - Tablespace Free Space Avg Fragmentation Pct on SWB



Fragmentation Pct is calculated by dividing the number of data files for a

 tablespace by the number of different chunks of free space within those 

data files.  The lower the number, the more fragmented your free space is.



                                                                   %chg

Tablespace                                                  Today since

   Name           09/18 09/19 09/20 09/21 09/22 09/23 09/24 09/25  yest

----------------- ----- ----- ----- ----- ----- ----- ----- ----- -----

SYSAUX             16.7  20.0  16.7    .5    .6    .8   2.3   1.0  -1.3

UNDOTBS1             .3    .3    .3    .2    .2    .2    .3    .3    .0



etc. etc. etc.

this is all I want printed out (or sent to to a file or whatever):

PHP Code:


			
09/25/06      SPCCHK - Tablespace Percent Total Free Values on SWB

                                                                   %chg Days

Tablespace                                                  Today since till

   Name           09/18 09/19 09/20 09/21 09/22 09/23 09/24 09/25  yest zero

----------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----

BDR_DATA           89.5  89.5  89.4  89.4  89.4  89.3  89.3  89.1   -.2

SYSAUX             71.0  70.5  70.0  71.5  71.1  70.6  70.0  71.4   1.4

SYSTEM             22.7  22.7  22.7  22.7  22.7  22.6  22.2  22.2    .0  297

UNDOTBS1           21.8  21.8  22.5  31.0  30.8  29.8  29.9  30.9   1.0

grial · #2 09-26-2006

Perhaps this is what you want:

Code:

#!/bin/bash

TOK1="SPCCHK - Tablespace Percent Total Free Values"
TOK2="SPCCHK - Tablespace Free Space Avg Fragmentation"

INTERESTING=no
while read l; do
   TXT1=$(echo $l | grep "$TOK1")
   TXT2=$(echo $l | grep "$TOK2")
   if [[ "$TXT1" != "" ]]; then
      INTERESTING=yes
   elif [[ "$TXT2" != "" ]]; then
      INTERESTING=no
   fi
   if [[ "$INTERESTING" == "yes" ]]; then
      echo "$l"
   fi
done < ./input_file.txt

Script for bash, and probably for ksh. Needs that "./input_file.txt" exists.

Regards.

anbu23 · #3 09-26-2006

Code:

sed -n "/Tablespace Percent Total Free/,/Tablespace Free Space Avg Fragmentation/ p" file | sed "$ d"

vgersh99 · #4 09-26-2006

something to start with:

nawk -v pat='Tablespace Percent Total Free' -f duck.awk myReportFile.txt

duck.awk:

Code:

BEGIN {
   RS=FS=""
}
$1 ~ pat

anbu23 · #5 09-26-2006

Code:

sed -n "/Tablespace Percent Total Free/,/Tablespace Free Space Avg Fragmentation/{ /Tablespace Free Space Avg Fragmentation/!p; }" file

Da_Duck · #6 09-26-2006

thanks for the quick responses.

Also, what if there is more than one block (same rules) within the same filename that I need to extract?
So there would be 2-3 sets of markers possibly.

anbu23 · #7 09-26-2006

If you have same kind of markers then you will get all those blocks

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to grab the value of field before the line reached	ahjiefreak	Shell Programming and Scripting	3	03-28-2008 02:59 AM
grab the line using awk	cdfd123	Shell Programming and Scripting	1	10-10-2007 05:21 AM
grab next consecutive line or lines	wisher115	Shell Programming and Scripting	1	12-07-2006 05:01 AM
how to print out line numbers of a text file?	forevercalz	Shell Programming and Scripting	4	12-12-2005 02:04 AM
add line numbers	esham	Shell Programming and Scripting	4	03-07-2005 07:46 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode