Databases
StackOverflow2013
Postsdbo
POReplace multiple <br> into single <br> using C# or Jquery
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReplace multiple <br> into single <br> using C# or Jquery
    primarykey
    data
    text
    <p>Which contains multiple \r\n and when I used </p> <pre><code>Regex.Replace(sampleText, @"[\r\n]{2,}", "&lt;br /&gt;"); </code></pre> <p>it changes it to with multiple <code>&lt;br&gt;</code> for multiple \n. I need to replace these multiple <code>&lt;br&gt;</code> with single <code>&lt;br /&gt;</code></p> <p>the text after Regx is:</p> <pre><code>Addendum 5 changes the following:&lt;div&gt;&lt;br&gt;&lt;/div&gt;div&lt;br&gt;div&amp;gt;&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Addenda 5 - Landscape &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;&amp;nbsp; &lt;br&gt;Item &lt;br&gt;Description &lt;br&gt;Qty &lt;br&gt;Unit &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Add &lt;br&gt;Pavestone Hollandstone Pavers&lt;span style=""&gt;&amp;nbsp;&lt;br&gt;span&amp;gt; &lt;br&gt;Colo&lt;br&gt;to&lt;br&gt;e dark&lt;br&gt;own.&lt;span style=""&gt;&amp;nbsp;&lt;br&gt;span&amp;gt;Base material not specified. Pavers to&lt;br&gt;e &lt;br&gt;ADA compliant. &lt;br&gt;478 &lt;br&gt;SF &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Area w&lt;br&gt;Calgary &lt;br&gt;Carpet Junipe&lt;br&gt;is clouded on sheet L5.1. Unable to determine what changed in &lt;br&gt;that area. &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Prunus laurocerasus 'Otto Luykens', 5 gal &lt;br&gt;Otto Luykens Laurel &lt;br&gt;-1 &lt;br&gt;EA &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Miscanthus sinensis&lt;span style=""&gt;&amp;nbsp; &lt;br&gt;span&amp;gt;'Morning Light', 5 gal &lt;br&gt;Morning Light Miscanthus &lt;br&gt;-3 &lt;br&gt;EA &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Add &lt;br&gt;Rose 'Knockout', 5 gal &lt;br&gt;Rose Knockout &lt;br&gt;11 &lt;br&gt;EA &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Turf-N Tee Mulch&lt;span style=""&gt;&amp;nbsp;&lt;br&gt;span&amp;gt; &lt;br&gt;Install 1 1/2" depth mulch &lt;br&gt;@ 42 sf.&lt;span style=""&gt;&amp;nbsp;&lt;br&gt;span&amp;gt;50% fo&lt;br&gt;each mulch type &lt;br&gt;-0.1 &lt;br&gt;CY &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Wood Shavings Mulch &lt;br&gt;Install 1 1/2" depth mulch &lt;br&gt;@ 42 sf.&lt;span style=""&gt;&amp;nbsp;&lt;br&gt;span&amp;gt;50% fo&lt;br&gt;each mulch type &lt;br&gt;-0.1 &lt;br&gt;CY &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;12-8-8 Gro-Power &lt;br&gt;Mix into planting areas at 75 &lt;br&gt;lbs/1000 sf @ 42 sf pe&lt;br&gt;spec 329500-3.6. &lt;br&gt;-3 &lt;br&gt;LBS &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;5-3-1 Gro-Powe&lt;br&gt;Plus &lt;br&gt;Mix into planting areas at 150 &lt;br&gt;lbs/1000 sf @ 42 sf pe&lt;br&gt;spec 329500-3.6. &lt;br&gt;-6 &lt;br&gt;LBS &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Flou&lt;br&gt;of Sulfur &lt;br&gt;Mix into planting areas at 20 &lt;br&gt;lbs/1000 sf @ 42 sf pe&lt;br&gt;spec 329500-3.6. &lt;br&gt;-1 &lt;br&gt;LBS &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Gro-Safe Activated Charcoal &lt;br&gt;Mix into planting areas at 200 &lt;br&gt;lbs/1000 sf @ 42 sf pe&lt;br&gt;spec 329500-3.6. &lt;br&gt;-8 &lt;br&gt;LBS &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Plant Backfill: Compost &lt;br&gt;Apply 20% compost mix and 80% &lt;br&gt;native soil pe&lt;br&gt;detail B/L5.6. &lt;br&gt;-1 &lt;br&gt;LS &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Plant Backfill: Nitrogenized &lt;br&gt;Stabilized Organic Amendment &lt;br&gt;Fo&lt;br&gt;all container-sized plants, &lt;br&gt;ackfill shall&lt;br&gt;e a uniform mixture of the following ingredients&lt;br&gt;y volume): &lt;br&gt;6 parts&lt;br&gt;y volume on-site soil, 4 parts&lt;br&gt;y volume nitrogen stabilized organic &lt;br&gt;amendment, Grow powe&lt;br&gt;pe&lt;br&gt;manufacturers'&lt;br&gt;ecommendation, 2 lbs. iron sulfate &lt;br&gt;pe&lt;br&gt;cubic yard of mix pe&lt;br&gt;spec 329500-3.6. &lt;br&gt;-1 &lt;br&gt;LS &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Plant Backfill: 5-3-1 Gro-Power &lt;br&gt;Plant Backfill: 7-5 gal @ 1 cup &lt;br&gt;pe&lt;br&gt;specs 329500-3.6.&lt;span style=""&gt;&amp;nbsp;&lt;br&gt;span&amp;gt; &lt;br&gt;-7 &lt;br&gt;Cups &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Plant Backfill: Flou&lt;br&gt;of Sulfate &lt;br&gt;Plant 7-5 gal @ 1/2 cup per &lt;br&gt;specs 329500-3.6.&lt;span style=""&gt;&amp;nbsp;&lt;br&gt;span&amp;gt; &lt;br&gt;-3.5 &lt;br&gt;Cups &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;Plant Backfill: Gro-Safe &lt;br&gt;Plant Backfill:7-5 gal @ 1 cup &lt;br&gt;pe&lt;br&gt;specs 329500-3.6.&lt;span style=""&gt;&amp;nbsp;&lt;br&gt;span&amp;gt; &lt;br&gt;-7 &lt;br&gt;Cups &lt;br&gt; &lt;br&gt; &lt;br&gt; &lt;br&gt;Deduct &lt;br&gt;20-10-5&lt;span style=""&gt;&amp;nbsp;&lt;br&gt;span&amp;gt;Plante&lt;br&gt;Tablets &lt;br&gt;- 21 gram &lt;br&gt;Apply to planting pits at:7-5 &lt;br&gt;gal @ 2 tablets pe&lt;br&gt;specs 329500-3.6. &lt;br&gt;-14.00 &lt;br&gt;EA &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;br&gt;div&lt;br&gt;div&lt;br&gt;div&amp;gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt; </code></pre> <p>Please help, Thanks.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLOZ
    1. USAnil D
    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
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POReplace multiple <br> into single <br> using C# or Jquery
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POReplace multiple <br> into single <br> using C# or Jquery
      1. USBuddhi Dananjaya
      1. VTBountyStart
    3. VO
      singulars
      1. POReplace multiple <br> into single <br> using C# or Jquery
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI see no reason why the regex you're using right now wouldn't already do this, unless there is whitespace on the blank lines (but there isn't in what you pasted in). Ahh I see I've been tricked by a bounty on a super old question.....
      singulars
      1. POReplace multiple <br> into single <br> using C# or Jquery
      1. USOGHaza
    2. COThat text is seriously messed up. `<br>Fo<br>all container-sized plants,` I guess should be `<br>For all container-sized plants,` and there's more like that...
      singulars
      1. POReplace multiple <br> into single <br> using C# or Jquery
      1. USJerry
    3. COZalgo is the pony... http://stackoverflow.com/a/1732454/945456
      singulars
      1. POReplace multiple <br> into single <br> using C# or Jquery
      1. USJeff Bridgman
 

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