Shell Programming and Scripting

Hello -

I have a file that has the something like the following :

REM CREATE TABLE lots of text
REM table specifc creation text ;
REM ALTER TABLE lots of text
REM text specific to the the alter command
REM could be more lines of text;

What I need is to get all the lines for the ALTER TABLE statement up to the ending ; into a seperate file. There are multiple statements within the file and some could be one line some could span more than one line but they all end in a ;

Thanks in advance for your help.
Feliz

Code:

sed -n '/ALTER TABLE/,/;/p' file

You're not saying you want to remove the REMs at the beginning of line, so I didn't do that. If you want it after all, try something like

Code:

sed -n -e '/ALTER TABLE/,/;/{' -e 's/^REM //p' -e } file

Thank you. I also found that this did the trick for me.

awk '/ALTER/,/;/' zpdm1_tab.sql > zpdm1_con.sql

Thanks for your reply.