Shell Programming and Scripting

First of all, I know this can be more eassily done with perl or other scripting languages but, that's not the issue. I need this in sed. (or wander if it's possible )

I got a file (trace file to recreate the control file from oracle for the dba boys)
which contains

Code:

some lines
another line
...
STARTUP NOMOUNT
some lines
another line
...
a line ending with ;
STARTUP NOMOUNT
some lines
another line
...
a line ending with ;

The file contains also some lines in comment in between the others. These lines start with '#'

I want the part from the first "STARTUP NOMOUNT" untill the line before the second "STARTUP NOMOUNT" in 1 file and the part from the second "STARTUP NOMOUNT" untill the end in another file.

I know how to do this in ksh and I guess I would quickly find a solution in perl also but, now it's time to sharpen my sed skills

I already gor this

Code:

sed '/^STARTUP NOMOUNT/,/^STARTUP NOMOUNT/!d' ikke | sed '/^#/d' | sed '$d'

This will delete all the lines except those between the 2 occurences on "STARTUP NOMOUNT", next it will delete the lines in comment and finally it will delete the last line which is the second occurence of "STARTUP NOMOUNT". So, this gives me already 1 file with the first part.

But, how do I get the second part ?

I already tried

Code:

sed '/^STARTUP NOMOUNT/,$!d' ikke | sed '/^#/d' | sed '1,/^STARTUP NOMOUNT/d'

But, this deletes 1 line too many

Anyone an idea ?

I couldnt get your question very clearly...

If you give input and expected output, it would be useful for us.

Simply with awk:

Code:

awk '/STARTUP NOMOUNT/{i++}i{print > "file_" i}' infile

Franklin52,
nice trick, can you give some explication ?
Having the code is nice but, I would like to understand it also :-)
This makes it eassier to build on if other situations should occure

By the way, do you know a way to do this with sed ?

The awk code is very good. I modified it to not print the comments, as I think you had indicated you don't want those to print, should they show up between the STARTUP NOMOUNT and the line with the ";".

Code:

 
awk '/STARTUP NOMOUNT/{i++} i && $1 !~ /^#/ {print > "file_" i}' infile

To get the second section with sed you can first delete the first section with:

Code:

sed '/STARTUP NOMOUNT/,/STARTUP NOMOUNT/!d' ikke > temp

Get the second section:

Code:

sed -n '/STARTUP NOMOUNT/,/STARTUP NOMOUNT/p' temp > file2

With sed it's much more complicated then awk, so I think awk is *the* tool for such tasks:

Code:

awk '/STARTUP NOMOUNT/{i++}i{print > "file_" i}' infile

Explanation:

Code:

/STARTUP NOMOUNT/{i++}

If the pattern is match we increase a counter i

Code:

i{print > "file_" i}

If i is true (not 0) print the current line to the file file_i

Regards

sed -n `grep -n <reg_pattern> <filename> | head -2 | cut -d":" -f1`,`wc -l <filename> | cut -d" " -f1`p <filename>

This is for your satisfaction,.... this would work fine but not recommended... ppl hav given ideal solutions