Shell Programming and Scripting

CREATE VIEW view1
AS something
FROM table1 ,table2 as A, table3 (something FROM table4)
FROM table5, table6
USING file1
;
CREATE VIEW view1
FROM table1 ,table2 ,table6 ,table9
something
something
FROM table5 ,table (something FROM table4 ,table5(this is something FROM table8)
USING file2
;
CREATE VIEW view1
FROM table1 ,table2 ,table6 ,table8
something
something
FROM table5 ,table (something FROM table4 ,table5(this is something FROM table8)
USING file2
;
CREATE VIEW view1
FROM table1 ,table2 ,table6 ,table7
something
something
FROM table5 ,table7 (something FROM table4 ,table5(this is something FROM table8)
USING file2
;
CREATE VIEW view1
FROM table1 ,table2 ,table6 ,table6
something
something
FROM table5 ,table (something FROM table4 ,table5(this is something FROM table8)
USING file2
;

 
awk -v RS="CREATE VIEW" '/table7/' test.out

 view1
FROM table1 ,table2 ,table6 ,table7
something
something
FROM table5 ,table7 (something FROM table4 ,table5(this is something FROM table8)
USING file2
;

awk -v RS="CREATE" -v ORS="CREATE" '/table7/' test.out

==========================
 VIEW view1
FROM table1 ,table2 ,table6 ,table7
something
something
FROM table5 ,table7 (something FROM table4 ,table5(this is something FROM table8)
USING file2
;

awk 'BEGIN{RS=ORS=";\n"}/table7/' text

CREATE VIEW view1
FROM table1 ,table2 ,table6 ,table7
something
something
FROM table5 ,table7 (something FROM table4 ,table5(this is something FROM table8)
USING file2
;

perl -ne 'BEGIN{$/=";\n"} /table7/ and print' file

CREATE VIEW view1
FROM table1 ,table2 ,table6 ,table7
something
something
FROM table5 ,table7 (something FROM table4 ,table5(this is something FROM table8)
USING file2
;

#!/usr/bin/env bash

# @(#) s1       Demonstrate extraction by matching token in paragraph.
# cgep source:
# http://sourceforge.net/projects/cgrep/ (verified: 2016.06.29)

# Utility functions: print-as-echo, print-line-with-visual-space, debug.
# export PATH="/usr/local/bin:/usr/bin:/bin"
LC_ALL=C ; LANG=C ; export LC_ALL LANG
pe() { for _i;do printf "%s" "$_i";done; printf "\n"; }
pl() { pe;pe "-----" ;pe "$*"; }
db() { ( printf " db, ";for _i;do printf "%s" "$_i";done;printf "\n" ) >&2 ; }
db() { : ; }
C=$HOME/bin/context && [ -f $C ] && $C cgrep

FILE=${1-data1}

pl " Sample input data file $FILE:"
head $FILE

pl " Results:"
cgrep -D -w '^CREATE' +w '^;' table7 $FILE

exit 0

$ ./s1

Environment: LC_ALL = C, LANG = C
(Versions displayed with local utility "version")
OS, ker|rel, machine: Linux, 3.16.0-4-amd64, x86_64
Distribution        : Debian 8.4 (jessie) 
bash GNU bash 4.3.30
cgrep ATT cgrep 8.15

-----
 Sample input data file data1:
CREATE VIEW view1
AS something
FROM table1 ,table2 as A, table3 (something FROM table4)
FROM table5, table6
USING file1
;
CREATE VIEW view1
FROM table1 ,table2 ,table6 ,table9
something
something

-----
 Results:
CREATE VIEW view1
FROM table1 ,table2 ,table6 ,table7
something
something
FROM table5 ,table7 (something FROM table4 ,table5(this is something FROM table8)
USING file2
;