Hi Friends,

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 ')'
############
Input File
################################################## #########################
INSERT common..dividend
( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,

fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,

create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
)
VALUES (306181, 51758, '2007-05-11', '2007-05-21',
'2007-05-21', '2007-05-24', 0.19,
'I', 0.7426385949277784, null, 4.818, null,
null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
105,
105, 19874739, null
)

May 21, 2007 6:17:11 PM com.esdi.dividend.DividendAccrual
accrueDividends
INFO: START of accrual process for tid: 51745
May 21, 2007 6:17:11 PM com.esdi.dividend.DividendAccrual
accrueDividends
INFO: Instrument tid is 51745

INSERT common..dividend (

dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,

fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,

create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
)
VALUES (306177, 51745, '2007-05-11', '2007-05-21',
'2007-05-21', '2007-05-24', 0.015,
'I', 0.7426385949277784, null, 1.381, null,
null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
105,
105, 19874793, null
)

################################################## #########################

Output should be like following
======================
INSERT common..dividend
( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,

fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,

create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
)
VALUES (306181, 51758, '2007-05-11', '2007-05-21',
'2007-05-21', '2007-05-24', 0.19,
'I', 0.7426385949277784, null, 4.818, null,
null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
105,
105, 19874739, null
)
INSERT common..dividend
( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,

fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,

create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
)
VALUES (306181, 51758, '2007-05-11', '2007-05-21',
'2007-05-21', '2007-05-24', 0.19,
'I', 0.7426385949277784, null, 4.818, null,
null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
105,
105, 19874739, null
)


Thank you all in advance for your .

Regards
SK

sonal10july@gmail.com wrote:
> Hi Friends,
>
> 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 ')'

It's really hard to decipher your data [ - I hope that someday people
would take more care about how they present their data structures - ].

But you may try whether the following code suffices for your request...

awk '/INSERT/,/)/;/VALUES/,/)/' < inputfile > output_file


Janis


> ############
> Input File
> ################################################## #########################
> INSERT common..dividend
> ( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306181, 51758, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.19,
> 'I', 0.7426385949277784, null, 4.818, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874739, null
> )
>
> May 21, 2007 6:17:11 PM com.esdi.dividend.DividendAccrual
> accrueDividends
> INFO: START of accrual process for tid: 51745
> May 21, 2007 6:17:11 PM com.esdi.dividend.DividendAccrual
> accrueDividends
> INFO: Instrument tid is 51745
>
> INSERT common..dividend (
>
> dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306177, 51745, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.015,
> 'I', 0.7426385949277784, null, 1.381, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874793, null
> )
>
> ################################################## #########################
>
> Output should be like following
> ======================
> INSERT common..dividend
> ( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306181, 51758, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.19,
> 'I', 0.7426385949277784, null, 4.818, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874739, null
> )
> INSERT common..dividend
> ( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306181, 51758, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.19,
> 'I', 0.7426385949277784, null, 4.818, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874739, null
> )
>
>
> Thank you all in advance for your .
>
> Regards
> SK
>

sonal10july@gmail.com wrote:
> Hi Friends,
>
> 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 ')'
> ############
> Input File
> ################################################## #########################
> INSERT common..dividend
> ( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306181, 51758, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.19,
> 'I', 0.7426385949277784, null, 4.818, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874739, null
> )
>
> May 21, 2007 6:17:11 PM com.esdi.dividend.DividendAccrual
> accrueDividends
> INFO: START of accrual process for tid: 51745
> May 21, 2007 6:17:11 PM com.esdi.dividend.DividendAccrual
> accrueDividends
> INFO: Instrument tid is 51745
>
> INSERT common..dividend (
>
> dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306177, 51745, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.015,
> 'I', 0.7426385949277784, null, 1.381, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874793, null
> )
>
> ################################################## #########################
>
> Output should be like following
> ======================
> INSERT common..dividend
> ( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306181, 51758, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.19,
> 'I', 0.7426385949277784, null, 4.818, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874739, null
> )
> INSERT common..dividend
> ( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306181, 51758, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.19,
> 'I', 0.7426385949277784, null, 4.818, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874739, null
> )
>
>
> Thank you all in advance for your .
>
> Regards
> SK
>


sed -n "/[^']*INSERT /,/[^']*)/p;/[^']*VALUES /,/[^']*)/p;" file



--
Michael Tosch @ hp : com

Janis Papanagnou wrote:
> sonal10july@gmail.com wrote:
>> Hi Friends,
>>
>> 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 ')'
>
> It's really hard to decipher your data [ - I hope that someday people
> would take more care about how they present their data structures - ].
>
> But you may try whether the following code suffices for your request...
>
> awk '/INSERT/,/)/;/VALUES/,/)/' < inputfile > output_file
>
>

It is safer to ensure that INSERT and VALUE do not appear inside a 'string':

and an ERE needs \) to match a )

awk "/[^']*INSERT/,/[^']*\)/;/[^']*VALUES/,/[^']*\)/"


--
Michael Tosch @ hp : com

2007-05-22, 21:05(+02), Michael Tosch:
[...]
>> awk '/INSERT/,/)/;/VALUES/,/)/' < inputfile > output_file
>>
>>
>
> It is safer to ensure that INSERT and VALUE do not appear inside a 'string':
>
> and an ERE needs \) to match a )
>
> awk "/[^']*INSERT/,/[^']*\)/;/[^']*VALUES/,/[^']*\)/"
[...]

/[^']*INSERT/ is equivalent to /INSERT/
given that [^']* matches the empty string.

Maybe you meant /^[^']*INSERT/
which may miss a "INSERT" that is not inside '...' as in
'...' INSERT

--
Stéphane

Michael Tosch wrote:
> Janis Papanagnou wrote:
>
>> sonal10july@gmail.com wrote:
>>
>>> Hi Friends,
>>>
>>> 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 ')'
>>
>>
>> It's really hard to decipher your data [ - I hope that someday people
>> would take more care about how they present their data structures - ].
>>
>> But you may try whether the following code suffices for your request...
>>
>> awk '/INSERT/,/)/;/VALUES/,/)/' < inputfile > output_file
>>
>>
>
> It is safer to ensure that INSERT and VALUE do not appear inside a
> 'string':
>
> and an ERE needs \) to match a )

Not in awk. (You haven't tried?)

Janis

>
> awk "/[^']*INSERT/,/[^']*\)/;/[^']*VALUES/,/[^']*\)/"
>
>

sonal10july@gmail.com wrote:
> Hi Friends,
>
> 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 ')'
> ############
> Input File
> ################################################## #########################
> INSERT common..dividend
> ( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306181, 51758, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.19,
> 'I', 0.7426385949277784, null, 4.818, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874739, null
> )
>
> May 21, 2007 6:17:11 PM com.esdi.dividend.DividendAccrual
> accrueDividends
> INFO: START of accrual process for tid: 51745
> May 21, 2007 6:17:11 PM com.esdi.dividend.DividendAccrual
> accrueDividends
> INFO: Instrument tid is 51745
>
> INSERT common..dividend (
>
> dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306177, 51745, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.015,
> 'I', 0.7426385949277784, null, 1.381, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874793, null
> )
>
> ################################################## #########################
>
> Output should be like following
> ======================
> INSERT common..dividend
> ( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306181, 51758, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.19,
> 'I', 0.7426385949277784, null, 4.818, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874739, null
> )
> INSERT common..dividend
> ( dividend_id,tid,declared_date,ex_date,record_date, pay_date,amount,interim_final_flag,
>
> fx_rate,stock_option_ratio,stock_price,treaty_tax_ rate,non_treaty_tax_rate,currency_code,
>
> create_date,update_date,create_user_id,update_user _id,cam_id,orig_cam_id
> )
> VALUES (306181, 51758, '2007-05-11', '2007-05-21',
> '2007-05-21', '2007-05-24', 0.19,
> 'I', 0.7426385949277784, null, 4.818, null,
> null, 'EUR', '2007-05-11 03:04', '2007-05-11 03:04',
> 105,
> 105, 19874739, null
> )
>
>
> Thank you all in advance for your .
>
> Regards
> SK
>

Presumably something along the lines of:

gawk '{if($0~"INSERT"){t=0rint $0
while(t<2){getlinerint $0;if($0~"\)"){t+=1}}}
}' file


Regards,
Geoff

2007-05-22, 21:16(+02), Janis Papanagnou:
[...]
>> and an ERE needs \) to match a )
>
> Not in awk. (You haven't tried?)
[...]

$ awk '/)/'
awk: line 1: regular expression compile failed (missing '(')

Don't assume what is true in gawk is true in every awk
implementation.

POSIX requires the ")" do be escaped here, though it doesn't
require an awk implementation to treat un unmatched ")" as an
error.

--
Stéphane