Extract text between two strings

Shell Programming and Scripting
1

Hi,
I have a text like these:

ECHO "BEGGINING THE SHELL....."
MV FILE1 > FILE2
UNIQ_ID=${1}
PARTITION_1=`${PL}/Q${CON}.KSH  "SELECT ....."
PARTITION_2=`${PL}/Q${CON}.KSH  "SELECT  ........"
${PL}/Q${CON}.KSH  "CREATE ...."
IF ....
.......

I would like to extract only text that only begins with ${PL}/Q${CON}.KSH " and ends in " to extract only the sql statements.
Do you know how could I make these.
I prefer with awk.
Thanks and sorry for my English!

2

No attempts from your side?

For your extremely simplified sample - which I doubt reflects reality - Try

awk '/\${PL}\/Q\${CON}\.KSH/ {print $2}' FS=\" file
SELECT .....
SELECT  ........
CREATE ....
3

Many thanks,
I have other code that is:

${ARQ}/Q_${UPPP}.SH "
SELECT * FROM MAX_TMP
WHERE ...
.....
.....
"

If I try these code doesn't works. I think that with these awk only get in the same line no?

4

The more versions of texts you have the more awk adaptions/versions you need, unless you find a general way to decribe all possible structures. For your second sample, try

 awk '/^"$/ {P=0} P;/\${ARQ}\/Q_\${UPPP}.SH \"/ {P=1}' FS=\" file
SELECT * FROM MAX_TMP
WHERE ...
.....
.....

This will fail for the slightest deviation from the file structure given, e.g. a trailing spaces in the last line.
Try to find the generic description, and it will be possible to find a general solution...

5

Mysql has a utility that might do what you want...
MySQL :: MySQL 5.1 Reference Manual :: 4.6.12 mysql_find_rows