title: Increment date based on time
body: <p>I need to increment a date by +1d based on the time.  This seems to be a bit over my head but I suspect it can be done with perl or maybe even awk.  For every timestamp with 0000, I need to increment the day by +1.</p>
  <p>input:</p>
  <pre><code>15,07/31/2020 1600,1048,31,0
  15,07/31/2020 1700,1086,45,0
  15,07/31/2020 1800,1092,42,0
  15,07/31/2020 1900,1017,20,1
  15,07/31/2020 2000,945,0,28
  15,07/31/2020 2100,897,0,43
  15,07/31/2020 2200,869,0,55
  15,07/31/2020 2300,812,0,72
  15,07/31/2020 0000,778,0,82
  </code></pre>
  <p>expected output:</p>
  <pre><code>15,07/31/2020 1600,1048,31,0
  15,07/31/2020 1700,1086,45,0
  15,07/31/2020 1800,1092,42,0
  15,07/31/2020 1900,1017,20,1
  15,07/31/2020 2000,945,0,28
  15,07/31/2020 2100,897,0,43
  15,07/31/2020 2200,869,0,55
  15,07/31/2020 2300,812,0,72
  15,08/01/2020 0000,778,0,82
  </code></pre>
  <p>It looks like awk can increment date but my question is how do I only increment the date on the lines with 0000 while still printing out the rest of the lines unaltered?</p>