need help with grep

[dewen]

I'm trying to find queries with multiple lines:

$query = "insert into 
{$db_name}.tbl_memo values
('xxx', xxx, ....)

Anyone help me with "grep" command to find these strings cross multiple lines?

Thx

[suntra]

What exactly do you mean ?

Are you trying to search through many queries (contained in an array ?) which contain more than one line (once trimmed) ? So containing \n (chr 10) and/or \r (chr 13) ?!

[dewen]

Hi, I'm trying to search thru different scripts for string containing "insert into .* tbl_memo", the matching could cross lines, like

"insert into
db_name.tbl_memo
values ...."

Hope this clear enough

Thanks

[dewen]

Any help appreciated. Does anyone know how to grep multiple lines? THANKs