title: data cleaning and formatting with awk or sed
body: <p>Here is an excerpt of my text file</p>
  
  <pre><code> namq_aux_lp   4 Last update of data 07.07.2014  t
   namq_aux_ulc   4 Last update of data 08.07.2014  
    namq_aux_gph   4 Last update of data 07.07.2014  
    prc_hicp_cann   4 Last update of data 17.07.2014 
   namq_nace10_k   4 Last update of data 02.07.2014  clas
  sei_bsco_m   4 Last update of data 10.06.2014  
  ei_bsin_m_r2   4 Last update of data 26.06.2014  
   lassei_bsbu_m_r2   4 Last update of data 26.06.2014  
  assei_bsrt_m_r2   4 Last update of data 26.06.2014  t
   ei_bssi_m_r2   4 Last update of data 26.06.2014  t
  ei_bsse_m_r2   4 Last update of data 26.06.2014  
   ei_bsci_m_r2   4 Last update of data 26.06.2014  
  10    sts_trtu_m   4 Last update of data 17.07.2014 c
  </code></pre>
  
  <p>I'm trying to format it and cleaning it, keeping it the first column and the date. However as you can see, there is the 10 on the last line. I cannot remove it because if I do, the date for <code>sei_bsco_m</code> will be amputated.</p>
  
  <p>Any help would be appreciated.</p>
  
  <p><strong>Note</strong> Code is here <a href="https://ideone.com/JbuRHK" rel="nofollow">https://ideone.com/JbuRHK</a></p>
  
  <p>Desired output would be :</p>
  
  <pre><code>namq_aux_lp     07.07.2014
  namq_aux_ulc    08.07.2014 
  ...
  assei_bsrt_m_r2 26.06.2014
  ...
  </code></pre>