title: Generate report in bash
body: <p>I'm trying to generate a summary report in bash. My text file format's this way:</p>
  
  <pre><code>title:composer:price:musical pieces available:musical pieces sold
  </code></pre>
  
  <p>However, in my report output's supposed to be this way :</p>
  
  <pre><code>Title       Composer   Price   PiecesAvail   PiecesSold   TotalProfit
  Graham      Jack       20.00       10            2           40.00
  Zack        Squall      4.00       5             3            7.00
  </code></pre>
  
  <p>Anyone can point me in the right direction? I would have to either calculate the total profit beforehand,or while generating the report.</p>
  
  <p>A sample of the textfile's here:</p>
  
  <pre><code> Graham:Jack:20.00:10:2
   Jack:Squall:4.00:5:3
   Random - One:Jim:5.00:4:1
   RainyDay:Melissa:50.00:2:1
  </code></pre>
  
  <p>I've not thought how to calculate the total profit yet though.</p>