title: formatting rows in a single file
body: <p>I am bit new to unix shell , i have a file like below</p>
  <p>cat dbschema</p>
  <pre><code>                  TABLE_NAME                  | TABLE_SIZE_BEFORE_RANDOM_MB
  ----------------------------------------------+-----------------------------
   SEC_CDS_SS |                    0.125000
  
                    TABLE_NAME                  | TABLE_SIZE_AFTER_RANDOM_MB
  ----------------------------------------------+----------------------------
   SEC_CDS_SS |                   0.125000
  
   TABLE_NAME  | TABLE_SIZE_BEFORE_RANDOM_MB
  -------------+-----------------------------
   CDS_EV|                   28.625000
  
   TABLE_NAME  | TABLE_SIZE_AFTER_RANDOM_MB
  -------------+----------------------------
   CDS_EV |                   0.500000
  </code></pre>
  <p>I need output like below in the same file like</p>
  <p>cat dbschema</p>
  <pre><code> TABLE_NAME                  | TABLE_SIZE_BEFORE_RANDOM_MB            TABLE_SIZE_AFTER_RANDOM_MB
  ----------------------------------------------+-----------------------------
   SEC_CDS_SS                     0.125000                               0.125000
   CDS_EV                          28.625000                              0.500000
  </code></pre>
  <p>Pipe as to be removed in the outfile as well,</p>
  <p>I tried matching the first column</p>
  <pre><code>awk '$1!=p{if(p)print s; p=$1; s=$0; next}{sub(p,x); s=s $0} END{print s}' dbschema
  </code></pre>
  <p>also tried some sed to concat 2 rows of a column</p>
  <pre><code>awk 'ORS=(NR%2==0) ?&quot;\n&quot; :&quot; &quot;' dbschema
  </code></pre>
  <p>none seems get me correct answer , any help much appreciated .. please</p>
  <p>also is their a way to ignore a echo line when running a sh file ??</p>
  <p>I have some line in my sh as</p>
  <pre><code>&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; TEST &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; (in sh files , this line should be ignored and proceed with further lines in that sh file )
  </code></pre>
  <p>Many thanks</p>