Re^6: Formatting 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 (Canon) 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.	[reply] [d/l]