title: How to remove blank spaces from SQL*Plus query?
body: <p>My query below being called from sqlplus is returning lot of spaces in the end of each value, how can I remove it?</p>
  
  <p>See example below:
  * I substituted the values with x</p>
  
  <pre><code>x            ,x                                                                                                                          
                                                                                                             ,x                             ,x                          ,x,x
  x
  </code></pre>
  
  <p>My query is: </p>
  
  <pre><code>set linesize 1000
  set trimspool on
  set trimout on
  set pagesize 0
  set colsep ,
  set feedback off
  
  spool /result.csv
  
  SELECT process_id,
    x1,
    x2,
    x3,
    x4,
    x5,
    x6,
    x
  FROM x
  WHERE x IN ('x');
  </code></pre>