Shell Programming and Scripting

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

Code:

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

Thanks a lot..

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

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

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 ";".

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