Well, my input file would consist of pulled SQLs such as the following: 
Select LTrim(RTrim(a.eeds_emp_id)) from whatever && Select Max(campaig
+n_key) from whatever......

[download]
THEN: I would enter a KEYWORD such as SELECT and it would search a line such as teh one above....say that it found the word SELECT...continue searching the line to see if there are any OTHER select statements in the line...if it is...then it count the line as having TWO Select statements and return a message saying...."this file contains SQLs with nested statements...etc. I know this may seem useless but for my project it is very necessary. With GREP, it is pulling the entire line and saying it is ONE SQL whereas I NEED it to pull that SQL and then run this program through the file to make sure I didn't miss any NESTED SQLS.

In reply to Re^2: searching for multiple strings in a line by dhudnall
in thread searching for multiple strings in a line by dhudnall

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.