<div>
perl -ne 'BEGIN{$t=shift}$c=$_ if/create\s+file/; /\b$t\b/&amp;&amp;print $c,$t,&quot;\n&quot;' mytable3 &lt;&nbsp;sampletext
</div>


perl -ne 'BEGIN{$t=shift}$c=$_ if/create\s+file/; /\b$t\b/&&print $c,$t,"\n"' mytable3 < sampletext

<div>
Sorry - should have said I'm using Ruby. Will this still work?
</div>


Sorry - should have said I'm using Ruby. Will this still work?

<div>
<div class="content wysiwyg-content">
Hi<br />
I have a large txt file where I want to return lines between a given condition eg<br />
sample text...<br />
create file 1<br />
select * from mytable1<br />
where id = 1<br />
create file 2<br />
select * from mytable3<br />
where id = 1<br />
create file 3<br />
select * from <br />
&nbsp; &nbsp; mytable3<br />
where id = 1<br />
<br />
.. I would like a regular expression where if I want to search for &quot;mytable3&quot; and what &quot;creat file&quot; name it is contained within.<br />
So, for &quot;mytable3&quot; the returned data should read...<br />
create file2<br />
mytable3<br />
create file3<br />
mytable3<br />
<br />
Help much appreciated
</div>
</div>


Hi
I have a large txt file where I want to return lines between a given condition eg
sample text...
create file 1
select * from mytable1
where id = 1
create file 2
select * from mytable3
where id = 1
create file 3
select * from 
    mytable3
where id = 1

.. I would like a regular expression where if I want to search for "mytable3" and what "creat file" name it is contained within.
So, for "mytable3" the returned data should read...
create file2
mytable3
create file3
mytable3

Help much appreciated

capturing text

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.