how to remove blank spaces ( not new lines ) and "/n" from file
<p>i have lot of files which are not formatted properly.</p>

<p>The data is something like this </p>

<pre><code>select *                  from table1 \n , table2
  select cnt(1) from                          table3
</code></pre>

<p>How can i remove unnecessary blank spaces and "/n"</p>

<p>result</p>

<pre><code>select * from table1,table2
select cnt(1) from table3
</code></pre>

<p>Thanks in advance</p>