in reply to Re^5: Formatting dates while parsing CSV
in thread Add leading zeros to days/months in dates while parsing CSV

So just adding the "(0) x3" will add zeros to any empty date fields, but format if there is an actual date?
  • Comment on Re^6: Formatting dates while parsing CSV

Replies are listed 'Best First'.
Re^7: Formatting dates while parsing CSV
by soonix (Chancellor) on Jun 14, 2016 at 20:32 UTC
    it appends a list of three elements (each containing a zero). So if the split returns a list of three, you end up with six elements (where you take the first three and ignore the rest); if there's nothing to split, you end up with the three freshly appended zeroes.

    Probably exactly what you want.