submitted 10 months ago* (last edited 10 months ago) by PracticalReputation@lemmy.world to c/plaintextaccounting@lemmy.world

2 comments fedilink hide all child comments

I have a csv file I'd like to read, seems I'm correct other than parsing the date. The csv file shows the date like so: ""2023-03-04 07:54:33"

I've tried a bunch without success. I feel it should be:

date-format %Y-%M-%D %H:%M:%S

But nope, getting an error it can not parse it.

top 2 comments

sorted by: hot top controversial new old

[-] IronyHammer@lemmy.world 4 points 10 months ago

You have %M as both month and minute. Double check what each individual date part is meant to be.

[-] PracticalReputation@lemmy.world 2 points 10 months ago

Thanks for pointing that out, it was one of the problems, the solution was using: date-format %Y-%m-%d %H:%M:%S

Next problem was I forgot to add skip 1 at the top.

this post was submitted on 27 Dec 2023

5 points (100.0% liked)

Plain Text Accounting

151 readers

1 users here now

Bookkeeping and accounting with plain text files and scriptable, command-line-friendly software, such as Ledger, hledger, or Beancount.

founded 1 year ago

MODERATORS