Shell Programming and Scripting

Hi,

I have a directory nsk,
files a.sql, b.sql, c.sql, d.sql,

assuming that I have line 'INSERT ALL INTO abc' in a.sql and c.sql

I need to list a filename, line number and complete line which contains ''INSERT ALL INTO abc' irrespective of case.

also in my files mentioned 'INSERT ALL INTO abc' may be splitted into 4 lines/3 lines i.e., it may not be in single line

'INSERT ALL INTO abc' can be present as 'INSERT
ALL INTO abc'
'INSERT ALL INTO abc' can be present as 'INSERT ALL
INTO
abc'

So, please provide me the command which gives the above command satisfying the above requirements,


Thanks for your help in advance,

smthg like

Code:

grep -ni 'INSERT ALL INTO abc' ./nsk/?.sql

Try this one, sed script:

Code:

 
/[Ii][Nn][Ss][Ee][Rr][Tt]/,/[Aa][Bb][Cc]/{ =
p
}

I didn't get anyoutput in that case

Do you have table names as "abc"? The above sed script should print lines between Insert and abc.