Databases
StackOverflow2013
Postsdbo
PORegex to turn all multi-line html <td></td> combinations into one line EXCEPT those nested within another <td></td>
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORegex to turn all multi-line html <td></td> combinations into one line EXCEPT those nested within another <td></td>
    primarykey
    data
    text
    <p>Trying to figure out a way with regex to turn all multi-line html td combinations into one line EXCEPT those nested within another td</p> <p>I'm trying to do a find-and-replace in visual studio (but I could use something else like wildedit, etc) to find all td tags that run across multiple lines, and put them all on one line. I want to remove all returns/tabs. The problem is though, that I don't want to do this to the parent td's if I have another table nested inside them.</p> <p>So for example I want to transform this:</p> <pre><code>&lt;table class="Top"&gt; &lt;tr&gt; &lt;td class="TopLeft"&gt; &lt;img src="img/spacer.gif" class="Size"&gt; &lt;/td&gt; &lt;td class="TopTile"&gt; &lt;img src="img/spacer.gif" class="Size"&gt; &lt;/td&gt; &lt;td class="TopRight"&gt; &lt;img src="img/spacer.gif" class="Size"&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="LeftTile"&gt; &amp;nbsp; &lt;/td&gt; &lt;td class="TitleBar"&gt; Blah Blah Blah &lt;/td&gt; &lt;td class="RightTile"&gt; &amp;nbsp; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="LeftTile"&gt; &amp;nbsp; &lt;/td&gt; &lt;td&gt; &lt;table cellpadding="2" cellspacing="0" border="0" class="EntryLight"&gt; &lt;tr&gt; &lt;td class="TopLeft"&gt; &lt;img src="img/spacer.gif" class="Size"&gt; &lt;/td&gt; &lt;td class="TopTile"&gt; &lt;img src="img/spacer.gif" class="Size"&gt; &lt;/td&gt; &lt;td class="TopRight"&gt; &lt;img src="img/spacer.gif" class="Size"&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="LeftTile"&gt; &amp;nbsp; &lt;/td&gt; &lt;td class="TitleBar"&gt; Blah Blah Blah &lt;/td&gt; &lt;td class="RightTile"&gt; &amp;nbsp; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre> <p>Into this:</p> <pre><code>&lt;table class="Top"&gt; &lt;tr&gt; &lt;td class="TopLeft"&gt;&lt;img src="img/spacer.gif" class="Size"&gt;&lt;/td&gt; &lt;td class="TopTile"&gt;&lt;img src="img/spacer.gif" class="Size"&gt;&lt;/td&gt; &lt;td class="TopRight"&gt;&lt;img src="img/spacer.gif" class="Size"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="LeftTile"&gt;&amp;nbsp;&lt;/td&gt; &lt;td class="TitleBar"&gt;Blah Blah Blah&lt;/td&gt; &lt;td class="RightTile"&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="LeftTile"&gt;&amp;nbsp;&lt;/td&gt; &lt;td&gt; &lt;table cellpadding="2" cellspacing="0" border="0" class="EntryLight"&gt; &lt;tr&gt; &lt;td class="TopLeft"&gt;&lt;img src="img/spacer.gif" class="Size"&gt;&lt;/td&gt; &lt;td class="TopTile"&gt;&lt;img src="img/spacer.gif" class="Size"&gt;&lt;/td&gt; &lt;td class="TopRight"&gt;&lt;img src="img/spacer.gif" class="Size"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="LeftTile"&gt;&amp;nbsp;&lt;/td&gt; &lt;td class="TitleBar"&gt;Blah Blah Blah&lt;/td&gt; &lt;td class="RightTile"&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSoteriologist
    1. USSoteriologist
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CO"Nesting" and "regex" are rather incompatible concepts. You can manage it with some dirty tricks iff you have Visual Studio 2012, but only then, because that's the first version that uses the .NET regex library.
      singulars
      1. PORegex to turn all multi-line html <td></td> combinations into one line EXCEPT those nested within another <td></td>
      1. USTim Pietzcker
 

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