Allow multiple colums for balance

[TiborUdvari]

My bank statements have one column for deposits and one for withdrawals.
The withdrawals are marked as negative numbers. It would be elegant to be able to set --balance=1,2 for example for this use case, as is for the longtext argument.

[mrVanDalo]

Hey @TiborUdvari sorry for the long delay.

So you have a CSV with a colum deposit and a colum withdraw. And one of the columns is always 0 and the other one holds a number which is always negative in the withdraw column and always positive in the deposit column?

If so you could pre-process your csv using miller.

mlr --icsv --opprint put '$balance = $deposit + $withdraw' ./test.csv 

and than simply use the balance column.

I will don't really have time right now to fulfill your request, (maybe in some month, but this fix might help you till than)

[TiborUdvari]

body{font-family:Consolas,Arial;font-size:13px}Thank you, this should do the trick temporarily!  On 29 March 2019 at 18:23:33, Ingolf Wagner ([email protected]) wrote: Hey @TiborUdvari sorry for the long delay. So you have a CSV with a colum deposit and a colum withdraw. And one of the columns is always 0 and the other one holds a number which is always negative in the withdraw column and always positive in the deposit column? If so you could pre-process your csv using miller. mlr --icsv --opprint put '$balance = $deposit + $withdraw' ./test.csv and than simply use the balance column. I will don't really have time right now to fulfill your request, (maybe in some month, but this fix might help you till than) — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.