Red S wrote: ... > I'm not sure I understand. What is the current output, and what would you > like it to be?
ok, i get sidetracked sometimes... :) thanks for getting this far! the fields are originally fed in as: DATE,TRANSACTION ID,DESCRIPTION,QUANTITY,SYMBOL,PRICE,COMMISSION,AMOUNT,REG FEE,SHORT-TERM RDM FEE,FUND REDEMPTION FEE, DEFERRED SALES CHARGE 12/29/2000,1,CASH ALTERNATIVES DIVIDENDS (ACCTNUMBER1),,,,,1.51,,,, 12/29/2000,2,CASH ALTERNATIVES PURCHASE (MMSWEEP1),1.51,MMSWEEP1,,,0.00,,,, 12/29/2000,3,CASH ALTERNATIVES PURCHASE,,,,,-1.51,,,, 12/29/2000,4,CASH ALTERNATIVES PURCHASE (MMSWEEP1),4.54,MMSWEEP1,,,0.00,,,, 12/29/2000,5,CASH ALTERNATIVES PURCHASE,,,,,-4.54,,,, 12/29/2000,6,CASH ALTERNATIVES INTEREST (MMSWEEP1),,MMSWEEP1,,,4.54,,,, ***END OF FILE*** here's the current output: ;; -*- mode: beancount -*- **** /home/me/fin/beancount/testing/test-trans.csv 2000-12-29 * "dividends" "dividends" Assets:SB:TDA:CASH 1.51 USD Income:SB:TDA:MM:Dividends:USD -1.51 USD 2000-12-29 * "transfer" "[MMSWEEP1] TDAmeritrade Sweep ACCT 1" Assets:SB:TDA:MMSWEEP1 1.51 MMSWEEP1 Assets:SB:TDA:Pass-Through -1.51 MMSWEEP1 2000-12-29 * "transfer" "transfer" Assets:SB:TDA:CASH 0 USD Assets:SB:TDA:Pass-Through -0 USD 2000-12-29 * "transfer" "[MMSWEEP1] TDAmeritrade Sweep ACCT 1" Assets:SB:TDA:MMSWEEP1 4.54 MMSWEEP1 Assets:SB:TDA:Pass-Through -4.54 MMSWEEP1 2000-12-29 * "transfer" "transfer" Assets:SB:TDA:CASH 0 USD Assets:SB:TDA:Pass-Through -0 USD 2000-12-29 * "income" "[MMSWEEP1] TDAmeritrade Sweep ACCT 1" Assets:SB:TDA:CASH 4.54 USD Income:SB:TDA:MM:Interest:MMSWEEP1 -4.54 USD **** /home/me/fin/beancount/testing/test-trans.csv ;; -*- mode: beancount -*- i'd like to take the TRANSACTION ID and DESCRIPTION fields and put them on one line as a comment or something and then i'd like the entire contents of the input data for that line put on the next line. so that this: 2000-12-29 * "transfer" "[MMSWEEP1] TDAmeritrade Sweep ACCT 1" Assets:SB:TDA:MMSWEEP1 4.54 MMSWEEP1 Assets:SB:TDA:Pass-Through -4.54 MMSWEEP1 ends up looking something like: 2000-12-29 * "transfer" "[MMSWEEP1] TDAmeritrade Sweep ACCT 1" ; ; TrID Desc: "4 CASH ALTERNATIVES PURCHASE (MMSWEEP1)" ; ; Raw Data: "12/29/2000,4,CASH ALTERNATIVES PURCHASE (MMSWEEP1),4.54,MMSWEEP1,,,0.00,,,," ; Assets:SB:TDA:MMSWEEP1 4.54 MMSWEEP1 Assets:SB:TDA:Pass-Through -4.54 MMSWEEP1 fin -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/eflmaj-qt72.ln1%40anthive.com.
