Shell Programming and Scripting

1: ### CREATE TABLE  ##
2: SOMETHING ELSE 1
3: ### CREATE TABLE  ##
4: ### CREATE   <spaces>
5: TABLE ###
6:SOMETHING ELSE 2
7: ##  CREATE
8: <spaces>   TABLE ###
9: SOMETHING ELSE 3

File1: 1: ### CREATE TABLE  ##
File1: 3: ### CREATE TABLE  ##
File1: 4: ### CREATE   <spaces>
File1: 5: TABLE ###
File1: 7: ##  CREATE
File1: 8: <spaces>   TABLE ###

s/CREATE TABLE/&/
/CREATE/ {N; s/CREATE *\n* *TABLE/&/p}

sed -f sedfile Filename

1: ### CREATE TABLE  ##
2: SOMETHING ELSE 1 CREATE
3: ### CREATE TABLE  ##
4: ### CREATE   <spaces>
5: TABLE ###
6:SOMETHING ELSE 2
7: ##  CREATE
8: <spaces>   TABLE ###
9: SOMETHING ELSE 3

1: ### CREATE TABLE  ##
2: SOMETHING ELSE 1 CREATE   // NOT NEEDED
3: ### CREATE TABLE  ##
4: ### CREATE   <spaces>
5: TABLE ###
7: ##  CREATE
8: <spaces>   TABLE ###

awk '/CREATE/||/TABLE/ {a=$0;gsub("#*","");for(i=2;i<=NF;i++) if($i != "CREATE" && $i != "TABLE") next; print FILENAME": "a}' File1 File2 File3 File4