[GNC] CSV tool
Plutocrat
plutocrat at gmail.com
Thu Jun 14 23:38:09 EDT 2018
I recently came across this tool for manipulating CSV data. It allows you to query a CSV file with SQL-like syntax. I thought that as there's a lot of that sort of thing going on in this group, some of you might find is useful.
http://harelba.github.io/q/
eg: q "SELECT COUNT(*) FROM ./clicks_file.csv WHERE c3 > 32.3"
P.
gnucash-user-request at gnucash.org wrote on Thursday, 14 June, 2018 03:48 PM:
> One of the problems I’ve found with gnucash is in the area of importing CSV formatted transactions. I figured out how to do it reasonably well for my
> bank statements, and now I’m turning my attention to my credit card accounts.
>
> I’m trying to enter in data that spans several years, and I have a collection of CSV files. In most cases I don’t have the ability to go back and get
> the data in a different format, such as some sort of Quicken file.
More information about the gnucash-user
mailing list