title: notepad++ - trying to reformat some stuff
body: <p>I have a CSV that basically has rows that look like:</p>
  
  <pre><code>06444|WidgetAdapter 6444|Description:
  
  Here is a description.
  Maybe some more.
  |0
  </code></pre>
  
  <p>The text in the third field is always different and varying, and I'm trying to replace all newlines within it only with <code>&lt;br&gt;</code>, so it ends up as</p>
  
  <pre><code>06444|WidgetAdapter 6444|Description: &lt;br&gt;Here is a description.&lt;br&gt;Maybe some more.&lt;br&gt;|0
  </code></pre>
  
  <p>edit:</p>
  
  <p>I basically need to get rid of all linebreaks so each line is a proper VALUE|VALUE|VALUE|VALUE. Normalize/beautify/clean it. </p>
  
  <p>None of my tools can import this properly, phpMyAdmin chokes, etc.
  There are linebreaks within the field, there are doublequotes that are not escaped, etc.</p>
  
  <p>Example other field: </p>
  
  <pre><code>08681|Book 08681|"Testimonial" - Person
  
  You should buy this.|
  </code></pre>
  
  <p>Example of another field:</p>
  
  <pre><code>39338|Itemizer||
  </code></pre>