Yes, that does it - thank you! David
On Fri, 17 Oct 2025 at 17:21, Dimitar Dimitrov <[email protected]> wrote: > I guess there are many variations, but how about this: `ledger bal -F > "%(commodity(display_total))\t%(quantity(display_total))\t%(account)\n"` > > Dimitar > On Friday, 17 October 2025 at 17:31:56 UTC+2 david whiting wrote: > >> Hi, >> >> I'm trying to change the format of the balance output and am struggling >> to do it. >> Using the default settings, I get something like: >> >> GBP -532,184.26 Income:Stuff >> GBP -13,259.50 Widgets >> GBP -223,450.08 Sprockets >> GBP -4,374.41 Other >> -------------------- >> GBP -532,184.26 >> >> I want to be able to remove the comma thousands separator and put a tab >> between the commodity and value and between the value and the accounts, >> e.g.: >> >> GBP\t-532,184.26\tIncome:Stuff >> >> I want to do this because I'm working on automating pivot tables that >> will have the account names as rows and time periods as columns, with >> amounts in the cells. I have it working already with a bash script that >> manipulates the ledger output (using sed to insert tabs and remove the >> commas) and an awk script that creates the pivot table, but the bash script >> is a bit of a hack and I think it would be cleaner if I can use >> --balance-format to insert the tabs and remove the commas from the amounts. >> >> The manual says that the default --balance-format is >> >> "%(justify(scrub(display_total), 20, -1, true, color))" >> " %(!options.flat ? depth_spacer : \"\")" >> "%-(ansify_if(partial_account(options.flat), blue if color))\n%/" >> "%$1\n%/" >> "--------------------\n" >> >> >> but I've been unable to use that explicitly using --balance-format and >> have been unable to get anything from my attempts to specify a >> --balance-format. >> >> Is it possible to do what I want to do? >> >> Thanks. >> >> David >> -- >> David Whiting >> > -- > > --- > You received this message because you are subscribed to the Google Groups > "Ledger" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/ledger-cli/e4439f91-25a5-4ad6-bbd0-c15a3a761bf9n%40googlegroups.com > <https://groups.google.com/d/msgid/ledger-cli/e4439f91-25a5-4ad6-bbd0-c15a3a761bf9n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- David Whiting -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/ledger-cli/CAK8-SWS_LAa19_1%3D6zas%2BkoUJmR8-Cb5iK8wa-W2RMFG3v%3DLqQ%40mail.gmail.com.
