search

cjhowald / ynab-csv

Tool for making your CSV files ready to import into YNAB
MIT License
2 stars 0 forks source link

Payee contains comma #1

Closed cjhowald closed 7 years ago

cjhowald commented 8 years ago

When a payee from export has a comma in it, the import silently fails for that row.

For example: 

Booking date;Value date;Transaction Type;Beneficiary / Originator;Payment Details;IBAN;BIC;Customer Reference;Mandate Reference;Creditor ID;Compensation amount;Original Amount;Ultimate creditor;Number of transactions;Number of cheques;Debit;Credit;Currency

11/07/2016;11/07/2016;"Debit Card Payment";;REAL,- BERLIN-WEDDI//BERLIN/DE 06-11-2016T14:38:30 Folgenr. 07 Verfalld. 1220;;;;;;;;;;;-105.27;;EUR

Converts to:

Date,Payee,Category,Memo,Outflow,Inflow
11/07/2016,REAL,- BERLIN-WEDDI//BERLIN/DE 06-11-2016T14:38:30 Folgenr. 07 Verfalld. 1220,,,,-105.27
cjhowald commented 7 years ago

Fixed, commas are now automatically removed from strings during conversion.