title: Remove Blank Lines from String SSRS
body: <p>I have a field in my SSRS report that has multiple carriage returns, for example:</p>
  
  <pre><code> First, get materials
  
  
  
   Next, glue them all together
  
   Last, let dry for two hours
  </code></pre>
  
  <p>All six lines are in in the one field, its not 7 rows.  I know I can replace/remove the carriage returns, but what I am really looking for is to be able to just remove the blank lines.  I would still want to keep the carriage returns on the lines that have text, like this:</p>
  
  <pre><code> First, get materials
   Next, glue them all together
   Last, let dry for two hours
  </code></pre>
  
  <p>I greatly appreciate any help on this.</p>
  
  <p>Thanks!</p>