title: Strip zeroes with regex in csv file
body: <p>I have csv file with decimal and integer numbers that represents amount of money, delimiter is semicolon. Example of file is:</p>
  
  <pre><code>00012,00;002200,21;00000;0000,00;0;
  450000,21;056,01;0023,50;000000000000;
  -032,23;-21.56;-00005630,05;
  </code></pre>
  
  <p>I have used this <code>\b0*([1-9][0-9]*\,|0)\b</code> to replace with <code>$1</code>like <a href="https://regex101.com/r/DKS0ov/2" rel="nofollow noreferrer">this</a>.</p>
  
  <p>However, the result must be:</p>
  
  <pre><code>12,00;2200,21;;0,00;;
  450000,21;56,01;23,50;;
  -32,23;-21.56;-5630,05;
  </code></pre>
  
  <p>So, if number is integer and has from 1 to unlimited number of <code>0</code> digits as result need to be empty (inserted in database as NULL), but if number is decimal the result must be <code>0,00</code>.</p>