There's probably a way to do it directly from the ledger command line, but if all else fails, you can easily do this using the "data > text to columns" in Google sheets.
On Tue, Dec 6, 2016 at 6:46 AM, Manish Rai Jain <[email protected]> wrote: > Thanks, that works! > > Follow up question, now I want to import the transactions into Google > sheets, so I'm using this flag to convert it to CSV. > --format '%D\t%P\t%t\n' > > For e.g. > 2016/08/22 Direct Debit Transaction 770.00 AUD > > The issue with this formatting is that the commodity is included in the > output. Ideally, just the numbers would be output, not the commodity (only > 770.00, not 770.00 AUD). Any way to achieve that? > > On Tue, Dec 6, 2016 at 4:43 AM, Martin Michlmayr <[email protected]> wrote: > >> * Manish R Jain <[email protected]> [2016-12-05 19:08]: >> > I track the reimbursements from my company on ledger. Some of these >> > are in USD and others in AUD. I want to send two expense reports >> > only containing transactions from that commodity. I couldn't figure >> > out a way to do so. Any suggestions about how to do this? >> >> You can use --limit: >> >> -l "commodity == 'USD'" >> >> -- >> Martin Michlmayr >> http://www.cyrius.com/ >> >> -- >> >> --- >> 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]. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > > --- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- Best regards, Daniël Bos Your government is reading your email. Slow them down with encryption. My public key: http://goo.gl/gms497 (4096 bit RSA, id EF2D5D91) Fingerprint : D8D0 9FBE F075 F709 7B52 2F73 326C 2123 EF2D 5D91 -- --- 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]. For more options, visit https://groups.google.com/d/optout.
