UNIX for Advanced & Expert Users

HI....

It's fallow up file ..
#./show.sh click enter button.. i am gettng the fallowup file. [like logs files] its keep on running every time why because there are lots of users working on it.

In that file i want to search pattern between two words
for ex:
SELECT DISTINCT publisher.asset_id AS asset_id, publisher.name AS name, publisher.status AS status, publisher.site_location AS site_location, publisher.site_name AS site_name, publisher.site_code AS site_code FROM access_control, publisher WHERE access_control.asset_id = publisher.asset_id AND access_control.network_id = 525 AND publisher.name != 'SYSTEM' AND publisher.status = 'A' ORDER BY publisher.name....... This is the pattern it's comming somewhere in that file.

I want that pattern ? how to find out that one?


i executed with sed comm

sed -n 's/select\distinct\publiser.asset_id/,/order\by\publiser.name/' but it'not working

Any help would be appreciated

awk '/select distinct publisher\.asset_id/,/order by publisher\.name/'

can we send unix variables as input for awk body & how?

go through the awk man page.. you will find everything...

how to select a field value of a record and store in unix user variable

give some example..
or sample input and output..

Edit: Oh another Hijacker - didn't notice at first; deleted the post's content!