Thanks for the quick responses. My answers to the inquiries for more info:
Each transaction is bound by <STMTTRN> ... </STMTTRN> Here's an example of a CREDIT amount (new semantics - charge to card) <TRNAMT>113.21 and a DEBIT (new semantics - payment to card) <TRNAMT>-1432.54 As you can see, no currency indicator, no = (equals sign) When the transform is complete, the TRNAMT values should be of opposite signs (as if they were multiplied by -1) Thanks for your help. Mark On Saturday, February 29, 2020 at 2:42:43 PM UTC-5, David G Wagner wrote: > > What do the currency numbers look like? I mean is there a dollar sign? Is > the minus sign at front or back? > > What you want to do is simple, but not familiar SGML. > > So if you can dummy some trans, would make it clearer to me... > > Wags ;) > WagsWorld > Hebrews 4:15 > Ph(primary) : 408-914-1341 > Ph(secondary): 408-761-7391 > On Feb 29, 2020, 09:58 -0800, Mark Love <[email protected] <javascript:>>, > wrote: > > I don't own BBEdit (yet) but think it could solve a problem I have. > > PROBLEM: > > My credit card company has recently switched the semantics of the QFX file > it produces to describe transactions. (For those not familiar with QFX, > it's SGML based descriptions of financial activity). Anyway, when it > worked properly charges to the card were described thusly: > > TRNTYPE=DEBIT > TRNAMT=<negative currency> > > and payments to the credit card company and merchant refunds were coded as: > > TRNTYPE=CREDIT > TRNAMT=<positive currency> > > A recent change to the generated GFX file semantics prevents me from > importing it into my personal finance software: all charges come through > as payments and all payments come through as charges. The root cause is > this new encoding in the QFX for charges: > > TRNTYPE=CREDIT > TRNAMT=<positive currency> > > and for payments: > > TRNTYPE=DEBIT > TRNAMT=<negative currency> > > As you can see, it's just the opposite from what it used to be!!! > > The credit card company insists this is correct (confirming that both > Quicken and MS Money say they're OK with the change). But it broke > Banktivity, and from spending over 6 hours on the phone with both > companies, I expect my only chance to solve this problem is with text > manipulation. Thus my interest in BBEdit. > > There seems to be some sort of automation capability in BBEdit where I > could run a series of transforms on the QFX file as delivered by the credit > card company before importing into Banktivity. Is this true, and can > someone describe the BBEdit commands to transform the QFX file properly? > Here's my take on the automation flow: > > > - open a specified file > - change all occurrences of CREDIT to XXX > - Change all occurrences of DEBIT to CREDIT > - Change all occurrences of XXX to DEBIT > - <I'm not sure how to transform the TRNAMT values in sign only > (basically, multiplying by -1)> > - Close transformed file > > Any help provided would be greatly appreciated. BBEdit is clearly > overkill for my problem, but for 50-odd bucks it seems worthwhile to me to > kill this aggravation. > > My environment: MacOS High Sierra (10.13.6) running on a MacBook Pro > early 2011 (to be upgraded this summer to Catalina on a MacBook Pro 16"). > > Thanks again. > > Mark > > -- > This is the BBEdit Talk public discussion group. If you have a feature > request or need technical support, please email "[email protected] > <javascript:>" rather than posting here. Follow @bbedit on Twitter: < > https://twitter.com/bbedit> > --- > You received this message because you are subscribed to the Google Groups > "BBEdit Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/bbedit/bc0dc03d-3b93-4bb4-bf9f-da0a5f436237%40googlegroups.com > > <https://groups.google.com/d/msgid/bbedit/bc0dc03d-3b93-4bb4-bf9f-da0a5f436237%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting here. Follow @bbedit on Twitter: <https://twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" 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/bbedit/be1fc712-3d6a-4b97-95cb-a7f94ea3feaa%40googlegroups.com.
