On Windows, those three lines turns to millions of lines ☹. I just stick with shell in case of *NIX or good old batch on Windows. In theory it is just adding a single comma before or after the value column based on value of another column.
-----Original Message----- From: Paul Kroitor <p...@kroitor.ca> Sent: Thursday, July 04, 2024 1:17 PM To: 'Kalpesh Patel' <kalpesh.pa...@usa.net>; gnucash-user@gnucash.org Subject: Re: [GNC] CSV Importer - Debit vs Credit I can easily write a little Python thingie and put it in my right-click menu, but it's just an added annoyance in this increasingly annoying world. -----Original Message----- From: Kalpesh Patel <kalpesh.pa...@usa.net> Sent: Thursday, July 4, 2024 12:59 PM To: 'Paul Kroitor' <p...@kroitor.ca>; gnucash-user@gnucash.org Subject: RE: [GNC] CSV Importer - Debit vs Credit Sadly, you will have to do some pre-processing before import. Put minus sign in front of debits or credits, depending upon how the book is setup. GNUCash does not have a conditional way of importing data in CSV by looking at a column. CSV files can be edited in any text editor. -----Original Message----- From: Paul Kroitor <p...@kroitor.ca> Sent: Thursday, July 04, 2024 11:30 AM To: gnucash-user@gnucash.org Subject: [GNC] CSV Importer - Debit vs Credit I'm sure this has been asked in a dozen different variations over the years but I'm now faced with the issue myself since I now need to use CSV for downloading (I hate TD Bank, who have removed the OFX download option). I can't immediately find any old messages describing this particular issue, so I thought I'd just ask. Simplified, TD Bank CSV downloads only basically have four fields: * Date * Description * "Debit" or "Credit" * Amount (always positive) Import works fine, except that I can't see any way (short of pre-editing the file) to get the CSV importer to understand that the amount field goes in a different column (D or C) depending on a different field's value. This must be fairly common - am I just blind? _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
