Thanks for the response. I checked the spacing between date and day-name and it wasn't the cause of the parse error. Running it through a preprocessor is simple enough, and I need to add a $ to the "amount" field anyway.
On Saturday, September 22, 2018 at 3:43:39 PM UTC-4, Dániel Fancsali wrote: > > Hello, > > Just a quick guess: are you sure, there's a single space between the date > and the day name? I've had a couple of sleepless nights over such things in > the past, so it might be worth checking. > > Also, I believe, those are locale dependent, but I assume your computer is > set to English. > > If all else fails, you can always pre-process the file, but I reckon, you > wanted to get away without any further magic... > > Regards, > Dan > > On Sat, 22 Sep 2018 at 19:39 Todd Roth <[email protected] <javascript:>> > wrote: > >> I'm trying to convert a credit card csv file to ledger and getting an >> error when parsing the date. >> >> *The command:* >> ledger -f sample.dat convert Transactions.csv --input-date-format >> "%m/%d/%Y %a" >> >> *The Error:* >> While parsing file "/Users/me/Downloads/Transactions.csv", line 1: >> While parsing CSV line: >> 06/21/2018 Fri,,"THE PAPER CANOE - DUCK, >> NC","XXXX-XXXXXX",,,157.53,,,,,,,, >> >> Error: Invalid date: 06/21/2018 Fri >> >> >> >> Is the above error the result of ledger not recognizing the %a parse >> parameter? Is there another --input-date-format I could use or do I need >> to clean the csv file prior to importing with the standard "%m/%d/%Y" >> format? >> >> >> Thanks. >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "Ledger" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
