title: Remove blank line from Spool file
body: <p>I am creating a .tab file using <code>Spool</code> simply by doing a select statement. </p>
  
  <p>The select statement returns Y</p>
  
  <p>However when running the below script the output files has a blank line after the Y.</p>
  
  <p>Can you please assist me in removing the line as I have tried looking all over.</p>
  
  <pre><code>Set Heading Off;
  SET NEWPAGE NONE;
  SET LINESIZE 1;
  SET PAGESIZE 0;
  SET TRIMSPOOL ON;
  SET SQLBLANKLINES OFF;
  SET FEEDBACK off;
  SET WRAP on;
  SPOOL \\Planning\Lists\Admin\elapse.tab;
  Select txt1 from ack_work_text_1;
  Spool Off;
  </code></pre>