Need to print certain lines from a file

jack00423 · #1 (**permalink**) 07-16-2008

Hi ALL,

I want to print lines from file using certain conditions
for exmple:
# The following commands will create a new control file and use it
# to open the database.
# The contents of online logs will be lost and all backups will
# be invalidated. Use this only if online logs are damaged.

;
ALTER DATABASE OPEN;
SIZE 2000M REUSE AUTOEXTEND OFF;
SIZE 2000M REUSE AUTOEXTEND OFF;
;
ALTER DATABASE OPEN RESETLOGS;
SIZE 2000M REUSE AUTOEXTEND OFF;
SIZE 2000M REUSE AUTOEXTEND OFF;

here i want to print lines between first occurance of ";" and second occurance of it.

Thanks
Jack

Annihilannic · #2 (**permalink**) 07-16-2008

Code:

awk '/^;$/ { while (getline && $0 !~ /^;$/) { print } ; exit }' inputfile > outputfile

jack00423 · #3 (**permalink**) 07-16-2008

Thanks a lot..

jack00423 · #4 (**permalink**) 07-16-2008

Hi,

I am new to scripting..
awk '/^;$/ { while (getline && $0 !~ /^;$/) { print } ; exit }' 6 > 7

could you please explain me what it does and how does it check.

Thanks
Jack

jack00423 · #5 (**permalink**) 07-17-2008

HII,

I want to print lines from file based on certain line
exapmple

RECOVER DATABASE
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP ADD TEMPFILE ;
ALTER TABLESPACE TEMP ADD TEMPFILE ;
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PATCH01" RESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 16
MAXLOGMEMBERS 5
MAXDATAFILES 512
MAXINSTANCES 1
MAXLOGHISTORY 7260
LOGFILE;

here i want to print from "ALTER DATABASE OPEN" till before startup nomount

Please help on this..

Thanks and Regards
Jack

Annihilannic · #6 (**permalink**) 07-17-2008

Here it is again with comments

Code:

awk '
    # for every line containing just a ";"
    /^;$/ {
        # read subsequent lines until we reach another one containing
        # just a ";"
        while (getline && $0 !~ /^;$/) {
            # print them
            print
        }
        # exit from the script (i.e. do not process any more lines)
        exit
    }
' inputfile > outputfile

To satisfy your new requirement you only need to modify the script slightly to search for different strings instead of ";".

jack00423 · #7 (**permalink**) 07-17-2008

Hi,

Instead of strings specifying...i want to print from certain line to line in file..
exapmple

RECOVER DATABASE
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP ADD TEMPFILE ;
ALTER TABLESPACE TEMP ADD TEMPFILE ;
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PATCH01" RESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 16
MAXLOGMEMBERS 5
MAXDATAFILES 512
MAXINSTANCES 1
MAXLOGHISTORY 7260
LOGFILE;

here i want to print from "ALTER DATABASE OPEN" till "MAXINSTANCES 1" line

Please help on this ..
Thanks
Jack

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to print data between 2 lines in a file	kamesh83	UNIX for Advanced & Expert Users	5	12-18-2008 12:14 PM
print all even lines of a txt file	ajp7701	Shell Programming and Scripting	1	04-17-2008 11:17 PM
How to print only lines in between two strings using awk	jisha	Shell Programming and Scripting	4	01-11-2008 04:13 AM
print selected lines	tonet	Shell Programming and Scripting	6	10-08-2007 05:50 AM
Print only certain lines from a text file	CamTu	Shell Programming and Scripting	1	06-01-2005 11:47 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: