title: How to sum column text file
body: <p>Hello everyone and I immediately apologize, as 
  I have seen various threads on the site, but unfortunately my knowledge is still insufficient to complete my project.
  I have a text file and I have to do the sum of each column (just need the total):</p>
  
  <pre><code>1003|name1|1208.00|2.00&amp;nbsp;&amp;nbsp;|96.00&amp;nbsp; |0.00|0.00|0.00|0.00|98.00&amp;nbsp; |90.95&amp;nbsp; |7.05&amp;nbsp; |8516.40
  1011|name2|1450.00|2.00&amp;nbsp;&amp;nbsp;|49.00&amp;nbsp; |0.00|0.00|0.00|0.00|51.00&amp;nbsp; |44.62&amp;nbsp; |6.38&amp;nbsp; |9243.7
  1004|name3|1450.00|25.00|170.00|0.00|0.00|0.00|0.00|195.00|175.75|19.25|27912.5 &lt;br&gt;
  1002|name4|765.00 &amp;nbsp;|1.00&amp;nbsp;&amp;nbsp;|17.00&amp;nbsp; |0.00|0.00|0.00|0.00|18.00&amp;nbsp; |15.13&amp;nbsp; |2.87&amp;nbsp; |2193.26
  </code></pre>
  
  <p>I need to get this(I have this file on linux then we can use Bash, PHP, Mysql... ): </p>
  
  <pre><code>1003|name1|1208.00|2.00&amp;nbsp;&amp;nbsp;|96.00&amp;nbsp; |0.00|0.00|0.00|0.00|98.00&amp;nbsp; |90.95&amp;nbsp; |7.05&amp;nbsp; |8516.40
  1011|name2|1450.00|2.00&amp;nbsp;&amp;nbsp;|49.00&amp;nbsp; |0.00|0.00|0.00|0.00|51.00&amp;nbsp; |44.62&amp;nbsp; |6.38&amp;nbsp; |9243.7
  1004|name3|1450.00|25.00|170.00|0.00|0.00|0.00|0.00|195.00|175.75|19.25|27912.5 &lt;br&gt;
  1002|name4|765.00 &amp;nbsp;|1.00&amp;nbsp;&amp;nbsp;|17.00&amp;nbsp; |0.00|0.00|0.00|0.00|18.00&amp;nbsp; |15.13&amp;nbsp; |2.87&amp;nbsp; |2193.26 &lt;br&gt;
  xxxx|Total&amp;nbsp; |4873.00|30.00|332.00|0.00|0.00|0.00|0.00|362.00 |326.45|35.55|47865.86
  </code></pre>
  
  <p>Where xxxx  is the Id number (No sum here).</p>
  
  <p>I've been trying to do this in PHP and MySQL -- No luck so far.</p>