Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I don't think this is an appropriate task for a regex. It is clearer to read through the file and accumulate the information you require line by line.</p> <p>This is a Perl solution that uses the sample data you provided.</p> <pre class="lang-perl prettyprint-override"><code>use strict; use warnings; my $info; while (&lt;DATA&gt;) { $info = '' if /Name :/; $info .= $_; print $info if /FAILED to INSERT/; } __DATA__ Name : ... INSERT INTO (...) Values (...) Name : ... &lt;--- These are the lines I need INSERT INTO (...) Values (...) &lt;--- &lt;span style='color:red;'&gt;FAILED to INSERT ...&lt;/span&gt; Name : ... INSERT INTO (...) Values (...) ... </code></pre> <p><strong>output</strong></p> <pre class="lang-none prettyprint-override"><code>Name : ... &lt;--- These are the lines I need INSERT INTO (...) Values (...) &lt;--- &lt;span style='color:red;'&gt;FAILED to INSERT ...&lt;/span&gt; </code></pre> <p>I hope it's clear how to read the data from a file instead. If you pass the file name on the command line then you can just change the loop to <code>while (&lt;&gt;) { ... }</code>.</p> <hr> <p><strong>Edit</strong></p> <p>For a one-line command solution, how about this</p> <pre><code>perl -0777 -ne"/FAILED to INSERT/ and print for split /(?=Name :)/" myfile </code></pre> <p><strong>output</strong> </p> <pre><code>Name : ... &lt;--- These are the lines I need INSERT INTO (...) Values (...) &lt;--- &lt;span style='color:red;'&gt;FAILED to INSERT ...&lt;/span&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PONeed a fairly complex regex for a simple text document
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBorodin
    1. USBorodin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COthank you, this looks like a good solution and is much more intuitive. I'll give it a whirl
      singulars
      1. PO
      1. USpclem12
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload