Michael Tosch wrote:
> surajkumar1@gmail.com wrote:
>
>> Hi Friends,
>>
>>
>> I posted this questions few hours back and got some replies also but
>> it's not opening.
>>
>>
>> I want all those lines lines from file starting with keyword 'INSERT'
>> and end with ')'
>> Note: In following example there are two ')' (one after 'INSERT' and
>> another after 'VALUES') . I want all those lines between INSERT and
>> second occurence of ')'
>
>
> Why not everything between INSERT and first following )
> and everything between VALUES and first following )
> ?

That's actually what my proposed solution was based upon;

awk '/INSERT/,/\)/;/VALUES/,/\)/'

that's two independent pattern ranges, each printing as default the
complete matching block.

>
> The result should be the same.
>
>

Janis