[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